操作系统监控cpu/io.
数据库主要监控下等待事件event,和对应的sql,根据情况再做分析:
SELECT S.SID, S.USERNAME, SW.EVENT, Q.SQL_TEXT
FROM V$SESSION S, V$SESSION_WAIT SW, V$SQL Q
WHERE S.USERNAME <> 'SYS'
AND Q.HASH_VALUE = S.SQL_HASH_VALUE
AND SW.SID = S.SID
AND S.STATUS = 'ACTIVE'
AND SW.EVENT NOT LIKE '%SQL*Net%'
ORDER BY LAST_CALL_ET DESC;
同时监控日志切换情况:
SELECT * FROM V$LOG;
------解决方案--------------------