Your database instance is started with a PFILE. Examine these parameters: (Exhibit) You want to increase

By | January 7, 2023

Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

Correct Answer: D
Reference:
https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#SQLRF00902