English Русский Contacts Site map Add to favorites
Registration
Login
Master braindump list
New braindumps
Submit a dump
Get latest dump
braindumps.com.ua
flame
3COM (7)
Adobe (1)
BEA (1)
Checkpoint (22)
Cisco (20)
Citrix (21)
CIW (15)
Compaq (0)
CompTIA (51)
CWNA (2)
EMC (2)
Exin (4)
GEJOS (4)
HDI (1)
HP (4)
IBM (13)
Juniper (5)
Linux Prof Institute (LPI) (2)
Lotus (11)
Microsoft (2462)
Network Appliance (2)
Novell (16)
Oracle (423)
PLSQL (1)
PMI (5)
SAS (1)
Sun (87)
Teradata (4)
Login:
Password:
RSS feed

Contacts
Certification links
Links
Authorized users can post comments.
Please log in or sign up.

back to list
Back to main forum
Oracle 9i: New Features For Administrators 

АвторSubject: Q41
written 19 January 2008 10:10   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
Oracle9i has enhanced the nature of SGA parameters; they are now dynamic. You can change the values of the shared pool and the buffer cache without restarting the database instance. The Oracle9i dynamic SGA concept enables you to take memory from one area of the SGA and allocate it to another area as needed while the database instance is up and running. Additionally, the unit of memory allocation for SGA is a granule in Oracle9i. At a minimum, one granule allocated for the shared pool, one for the buffer cache, and one for the redo log buffer. You can confirm a total amount of granules by checking the value of the column LO_SETID in the V$BUFFER_POOLS view. Oracle9i also introduces SGA_MAX_SIZE, a new static parameter that enables the DBA to start with a smaller SGA and dynamically increase it to the maximum value specified by SGA_MAX_SIZE.
If you do not set SGA_MAX_SIZE or if you set it to a value less than initial SGA size, you cannot increase the SGA size later.
Incorrect Answers:
1: The size of a granule is 4 MB if the SGA at startup is less than 128 MB; it will be 16 MB otherwise.
4: The size of the SGA components is not set by the SGA_MAX_SIZE parameter. They are only limited by SGA_MAX_SIZE value. As a DBA, you can dynamically change the value of the parameters DB_CACHE_SIZE, SHARED_POOL_SIZE, and LARGE_POOL_SIZE up to the size of SGA_MAX_SIZE.
Reference:
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 180-182
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 16-17
Chapter 1: Oracle9i Database Administration and Management Features

Current tread:
back to list

Q41 - Go to question 10:10 19.01.08

back to list
Up ^ gen. 0.048 Server date 10:45 09-01-2009 Developed by Zip © 2006 Up ^
Forum
Start online exam simulation
Master braindump
User braindumps
Main forum
Question comments