Which SGA parameter(s) would you modify?

You set SGA parameters in your database as:
DB_CACHE_SIZE=24
MB JAVA_POOL_SIZE=48
MB SHARED_POOL_SIZE=96 MB
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?

You set SGA parameters in your database as:
DB_CACHE_SIZE=24
MB JAVA_POOL_SIZE=48
MB SHARED_POOL_SIZE=96 MB
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 SHARED_POOL_SIZE to 116 MB

B.
change JAVA_POOL_SIZE to 58 MB and DB_CACHE_SIZE to 34 MB

C.
change SHARED_POOL_SIZE to 106 MB and DB_CACHE_SIZE to 34 MB

D.
change JAVA_POOL_SIZE to 68 MB

E.
change DB_CACHE_SIZE to 44 MB

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *