You receive this error regularly and have to shut down the database instance to overcome the error.
What can the solution be to reduce the chance of this error in future,when implemented?
A. setting the PRE_PAGE_SGA parameter to TRUE
B. locking the SGA in memory
C. increasing the value of SGA_MAX_SIZE
D. automatic memory management
答案：（D）
解析：
错误信息提示没有足够的shared memory，说明shared memory大小设置不合理，所以采用自动内存管理可以解决此问题