rgb_rgb的博客

set lines 120 pages 40column event format A40column PID format A10column P1_P2_P3_TEXT format A40column username format A10column osuser format A10column event format A30column sid form

在10gR2中,提供了$ORACLE_HOME/rdbms/admin/sqltrpt.sql脚本,用于抽取占用资源较多的sql,并可以为指定的sql生成执行计划,资源占用较多的sql分为两部分1 15 Most expensive SQL in the cursor cache2 15 Most expensive SQL in the workload repository @?/

原文：http://gavinsoorma.com/unix-for-the-dba/ Unix for the DBAHow to kill all similar processes with single command (in this case opmn)ps -ef | grep opmn |grep -v grep | awk '{print $2}' |xargs

select file#,checkpoint_change# from v$datafile;select file#,checkpoint_change# from v$datafile_header;等待大于2小时：select * from v$session where seconds_in_wait >=2*3600;  rman控制备份速度conf