|
Always tell us Oracle version.
When the problem happens, start with wait events (assuming 10g or up):
select sid, event, p1, p2, p3 from v$session where wait_class != 'Idle';
Check the alert.log:
tail -f alert_$ORACLE_SID.log
> 此时数据库的IDLE很高(90%左右)
So CPU usage is very low?
Yong Huang |
|