[Oracle] export ledba18 You can not set a value for the DB_8K_CHCHE_SIZE parameter., oracleparameter

Source: Internet
Author: User

[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

Related Article

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.