In the database instance running on a Linux machine, you receive an out-of-memory error due to
the undersizing of shared pool. You observed that the following error was recorded always during
peak hours in the trace file that is available in the USER_DUMP_DEST directory:
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 components 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.