What is the purpose of changing these parameters?

You executed the following command and restarted the Oracle database instance:
SQL> ALTER SYSTEM SET USE_INDIRECT_BUFFERS=TRUE SCOPE=SPFILE;
SQL> ALTER SYSTEM SET DB_BLOCK_BUFFERS=52144 SCOPE=SPFILE;
What is the purpose of changing these parameters?

You executed the following command and restarted the Oracle database instance:

SQL> ALTER SYSTEM SET USE_INDIRECT_BUFFERS=TRUE SCOPE=SPFILE;
SQL> ALTER SYSTEM SET DB_BLOCK_BUFFERS=52144 SCOPE=SPFILE;

What is the purpose of changing these parameters?

A.
To relocate the entire SGA to the shared memory file system

B.
To enable very large memory (VLM) for the Oracle database instance

C.
To disable very large memory (VLM) for the Oracle database instance

D.
To enable hugepages to manage the memory allocated to the Oracle database instance



Leave a Reply 0

Your email address will not be published. Required fields are marked *