Script
rgb_rgb
dba
展开
-
wait_details_10g_sql
set lines 120 pages 40 column event format A40 column PID format A10 column P1_P2_P3_TEXT format A40 column username format A10 column osuser format A10 column event format A30 column sid form原创 2012-08-22 15:49:17 · 648 阅读 · 0 评论 -
Automatic SQL Tuning Advisor
在10gR2中,提供了$ORACLE_HOME/rdbms/admin/sqltrpt.sql脚本,用于抽取占用资源较多的sql,并可以为指定的sql生成执行计划,资源占用较多的sql分为两部分 1 15 Most expensive SQL in the cursor cache 2 15 Most expensive SQL in the workload repository @?/原创 2012-08-26 19:09:44 · 2041 阅读 · 0 评论 -
Unix for the DBA
原文:http://gavinsoorma.com/unix-for-the-dba/ Unix for the DBA How to kill all similar processes with single command (in this case opmn) ps -ef | grep opmn |grep -v grep | awk '{print $2}' |xargs转载 2012-08-25 22:46:47 · 524 阅读 · 0 评论 -
oracle 常用SQL(不断更新)
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原创 2012-09-24 19:35:03 · 575 阅读 · 0 评论