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 PRE_PAGE_SGA initialization parameter to TRUE.
C.
Set the MEMORY_MAX_TARGET initialization parameter to zero.
D.
Set the SGA_TARGET initialization parameter to a nonzero value.
Why? I think f you set SGA_TARGET to zero Oracle autotune buffer chache.
yeah, i think that too, cause i read if you set the SGA_TARGET to zero the size of the SGA will be set or managed by oracle but i saw that the correct answer is to set the SGA_TARGET to nonzero I think it’s for the OLTP process, cause there’s a lot of space wasted :S
Manuel,
Now I understand. SGA to non-zero value will be autotune the diferente SGA areas (db buffer and shared pool).
Regards,
Luis