[Oracle] export ledba18 You can not set a value for the DB_8K_CHCHE_SIZE parameter., oracleparameter
You have set some of the initialization parameters:
DB_BLOCK_SIZE = 8 KB
SGA_MAX_SIZE = 2 GB
SGA_TARGET = 0
SHARED_POOL_SIZE = 120 MB
DB_CHCHE_SIZE = 896 MB
STREAM_POOL_SIZE = 0
LARGE_POOL_SIZE = 110 MB
Which two statements are correct? (Choose two ).
A. You can not set a value for the DB_8K_CHCHE_SIZE parameter.
B. If you increase the size of the large pool to 120 MB, then th e memory
Allocated to the shared poll will be allocated CED to 110 MB.
C. If the value for SGA_TARGET is changed to 1 GB and SHARED_POOL_SIZE is
120 MB, then memory cannot be taken from the shared pool, even I f the shared
Pool has free space available.
D. If an application attempts to allocate more than 120 MB from the shared
Pool and free space is available in the buffer pool, then the free space
From the buffer pool is allocated to the shared pool.
Answer: AC