You are working on a database instance with the following requirements:
1) During daytime, there is a large volume of transaction that requires a large database buffer cache.
2) In the night, batch jobs are run. These jobs require a higher value for the large pool.
You want to automate the configuration for the memory components so that the parameters are not required to be changed manually every day.
What would you do?
A.
Set the PRE_PAGE_SGA initialization parameter to TRUE.
B.
Set the SGA_TARGET initialization parameter to a nonzero value.
C.
Set the DB_BLOCK_BUFFERS initialization parameter to a nonzero value.
D.
Set the USE_INDIRECT_DATA_BUFFERS initialization parameter to TRUE.