【oracle】oracledba18 You can not set a value for the DB_8K_CHCHE_SIZE parameter.,oracleparameter

來源:互聯網
上載者:User

【oracle】oracledba18 You can not set a value for the DB_8K_CHCHE_SIZE parameter.,oracleparameter

You have set some of the initialization parameters as: 

DB_BLOCK_SIZE=8KB 

SGA_MAX_SIZE=2GB 

SGA_TARGET =0 

SHARED_POOL_SIZE=120MB 

DB_CHCHE_SIZE=896MB 

STREAM_POOL_SIZE=0 

LARGE_POOL_SIZE=110MB 

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 120MB, then th e memory 

allocated to the shared poll will be reduced to 110MB. 

C. If the value for SGA_TARGET is changed to 1GB and SHARED_POOL_SIZE is 

120MB, 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 120MB 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

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.