View the Exhibit to observe the error.
You receive this error regularly and have to shutdown the database instance to overcome the error. Automatic Shared Memory Management is configured for the instance. What can you do to reduce the chance of this error in the future?
A.
Increase the value of SGA_MAX_SIZE
B.
Enable automatic memory management
C.
Set the PRE_PAGE_SGA parameter to true
D.
Lock the System Global Area (SGA) in memory
I think ….
when you get the error ….
ORA-04031: unable to allocate string bytes of shared memory (“string”,”string”,”string”,”string”)
and it is related to shared pool out of memory, then you can do one of …
– use DBMS_SHARED_POOL package to pin large packages in the library cache, This reduces the chance of reloading and recompiling objects
– reduce your use of SHARED_POOL_SIZE
– increase the inits SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE.
THe first 2 options here are not included amoung the possible answers.
The 3rd option could however be achieved via …
Increase the value of SGA_MAX_SIZE
or
Enable automatic memory management … this is possible, because it could possibly take memory from the PGA, if it could spare this memory, and give it to the SGA.
Answer B looks better because
1. AMM is recommended, and is probably a better idea than receiving silly errors like this, even if you really have to manually set some setting you can still do it with AMM.
2. if you increase SGA_MAX_SIZE it will only work if you have that spare memory.