ORACLE SGA问题分析
select sum(value)/1024/1024 from v$sga; --查看SGA总大小
select current_size from v$buffer_pool; --查看当前高速缓冲池大小
select pool, sum(bytes)/1024/1024 Mbytes from v$sgastat group by pool --查看各池大小
2 java pool(java池) 4
3 streams pool(流池) 4
4 shared pool(共享池) 87.7224197387695
5 large pool(大池) 4
一般情况下,SGA = java pool + large pool + share pool + streams pool + current_size
所以,出现ORA-04031错误,请调整share_pool大小 或者 sga_target 大小。 oracle 10g是自动管理这些池的,sga_target为这些池之和。