What would you do to automate this configuration for the memory components with change in mode of working?

In a system, large online transaction processing (OLTP) jobs run during the daytime that
require a large database buffer cache. In the night, the system supports batch jobs that
require a higher value to be set for the large pool. You must simultaneously configure the
memory components to accommodate the peak requirement. What would you do to
automate this configuration for the memory components with change in mode of working?

In a system, large online transaction processing (OLTP) jobs run during the daytime that
require a large database buffer cache. In the night, the system supports batch jobs that
require a higher value to be set for the large pool. You must simultaneously configure the
memory components to accommodate the peak requirement. What would you do to
automate this configuration for the memory components with change in mode of working?

A.
Set the SGA_TARGET initialization parameter to zero.

B.
Set the SGA_TARGET initialization parameter to a nonzero value.

C.
Set the PRE_PAGE_SGA initialization parameter to TRUE.

D.
Set the MEMORY_MAX_TARGET initialization parameter to zero.



Leave a Reply 0

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