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 10 g . 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 10 g . 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 DB_CACHE_SIZE to 44 MB

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

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

D.
change JAVA_POOL_SIZE to 68 MB

E.
change SHARED_POOL_SIZE to 116 MB



Leave a Reply 1

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