In the database instance running on a Linux machine, you receive an ut-of-memory error due to the undersizing of shared pool. You observed that the following error was ecorded always during peak hours in the trace file that is available in the USER_DUMP_DEST irectory:
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 SGA omponents and you do not have scope to increase it further.
What would be one of the solutions to reduce the probability of getting this error in future?
A.
Implement hugepages in the system.
B.
Increase the swap space in the system.
C.
Set the PRE_PAGE_SGA parameter to TRUE.
D.
Implement Automatic Shared Memory Management.
Correct answer is D