在11gR2中DBRM(database resource manager,11gR2中新的后台进程,见
《Learning 11g New Background Processes》)会在Alert.log告警日志中反映OS操作系统最近5分钟是否有剧烈的swap活动了, 具体的日志如下:
WARNING: Heavy swapping observed on system in last 5 mins. pct of memory swapped in [3.07%] pct of memory swapped out [4.44%]. Please make sure there is no memory pressure and the SGA and PGA are configured correctly. Look at DBRM trace file for more details.进一步诊断可以观察DBRM后台进程的trace:
[oracle@vrh2 trace]$ cat VPROD2_dbrm_5466.trc Trace file /s01/orabase/diag/rdbms/vprod/VPROD2/trace/VPROD2_dbrm_5466.trc Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /s01/orabase/product/11.2.0/dbhome_1 System name:
本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1278231