You set SGA parameters in your database as:
DB_CACHE_SIZE=24MB
JAVA_POOL_SIZE=48MB
SHARED_POOL_SIZE=96MB
You plan to upgrade to Oracle Database 10g. You need to provide an additional 20 MB memory space to accommodate internal overhead allocations for metadata.
Which SGA parameter(s) would you modify?
A.
change JAVA_POOL SIZE to 68MB
B.
change DB_CACHE_SIZE to 44MB
C.
change SHARED_POOL_SIZE to 116MB
D.
change JAVA_POOL_SIZE to 58MB and DB_CACHE_SIZE to 34MB
E.
change SHARED_POOL_SIZE to 106MB and DB_CACHE_SIZE to 34MB
Explanation:
The SHARED_POOL_SIZE initialization parameter is a dynamic parameter that lets you specify or adjust the size of the shared pool component of the SG A. Oracle Database selects an appropriate default value. Starting with Oracle Database 10 g Release 1, the size of internal SGA overhead is included in the user-specified value of SHARED_POOL_SIZE. In other words, if you are not using the automatic shared memory management feature, then the amount of shared pool memory that is allocated at startup is exactly equal to the value of SHARED_POOL_SIZE initialization parameter. In manual SGA mode, this parameter must be set so that it includes the internal SGA overhead in addition to the desired value of shared pool size.REF: Oracle(r) 10g Administrator Guide, 2-31