"Oracle" Oracledba18 you can not set a value for the db_8k_chche_size parameter.

Source: Internet
Author: User

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 statements is correct? (Choose).

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 and then th e memory

Allocated to the shared poll is reduced to 110MB.

C. If the value for Sga_target are changed to 1GB and Shared_pool_size are

120MB, then memory cannot is 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 are available in the buffer pool, then the free space

From the buffer pool are allocated to the shared pool.

Answer:ac

"Oracle" Oracledba18 you can not set a value for the db_8k_chche_size parameter.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

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.