ORA-04031: unable to allocate 4000 bytes of shared memory On investigation, you found that SGA_MAX_SIZE was larger than the sum of the sizes of all System Global Area (SGA) components and you do not have the scope to increase it further. Identify a solution to reduce the probability of getting this error in future.
A. Set the PRE_PAGE_SGA parameter to TRUE
B. Set the LOCK_SGA initialization parameter to TRUE
C. Implement Automatic Shared Memory Management
D. Set the SGA_TARGET initialization parameter to zero
Answer:A
ORA-04031: unable to allocate 4000 bytes of shared memory On investigation, you found that SGA_MAX_SIZE was larger than the sum of the sizes of all System Global Area (SGA) components and you do not have the scope to increase it further. Identify a solution to reduce the probability of getting this error in future.
A. Set the PRE_PAGE_SGA parameter to TRUE B. Set the LOCK_SGA initialization parameter to TRUE C. Implement Automatic Shared Memory Management D. Set the SGA_TARGET initialization parameter to zero