点击(此处)折叠或打开
-
select snap_id, disk_reads_delta reads_delta,
-
executions_delta exec_delta, disk_reads_delta /decode
-
(executions_delta, 0, 1,executions_delta) rds_exec_ratio,
-
sql_id
-
from dba_hist_sqlstat
-
where disk_reads_delta > 100000
- order by disk_reads_delta desc;
| SNAP_ID | READS_DELTA | EXEC_DELTA | RDS_EXEC_RATIO | SQL_ID |
| 39 | 511106 | 1 | 511106 | 8h1qaqha580hh |
| 29 | 216898 | 3 | 72299.33 | d5bcqvumxr4y4 |
点击(此处)折叠或打开
-
select command_type,sql_text
-
from dba_hist_sqltext
- where sql_id='d5bcqvumxr4y4';
| COMMAND_TYPE | SQL_TEXT |
| 3 | select count(id) from bom |
同样可以查看之前命令的执行计划
点击(此处)折叠或打开
-
select *
- from table(DBMS_XPLAN.DISPLAY_AWR('8h1qaqha580hh'));