Oracle 11G OCP 1Z0-052 13

LuiseDalian發表於2014-06-05
(13)You have executed this command to change the size of the database buffer cache:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582;

System altered.

To verify the change in size, you executed this command:

SQL> SHOW PARAMETER DB_CACHE_SIZE

NAME TYPE VALUE

------------------- ----------- ------------------

db_cache_size big integer 4194304

Why is the value set to 4194304 and not to 2516582?

A. because 4194304 is the granule size

B. because 4194304 is the standard block size

C. because 4194304 is the largest nonstandard block size defined in the database

D. because 4194304 is the total size of data already available in the database buffer cache

答案:(A)

解析:

SGA元件分配和回收空間都是以granule為單位的。

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17013648/viewspace-1175892/,如需轉載,請註明出處,否則將追究法律責任。

相關文章