ITPub博客

首页 > 数据库 > Oracle > sql_monitor

sql_monitor

原创 Oracle 作者:xhailiang 时间:2017-03-29 23:18:00 0 删除 编辑

select * from v$sql_plan where sql_id  = '4zafy9ua4zmqr'


select * from dba_hist_sql_plan where sql_id  = '4zafy9ua4zmqr'


select * from v$sql_plan_monitor where sql_id = '6zw1yubxchmam'


SELECT * FROM V$SQL_MONITOR where first_refresh_time > sysdate - interval '5' minute


SELECT dbms_sqltune.report_sql_monitor(sql_id=>'65czba54aqx9f',type=>'TEXT') FROM DUAL


SELECT dbms_sqltune.report_sql_monitor_list(type=>'TEXT',report_level=>'ALL') FROM DUAL


select xmltype(binds_xml) from v$sql_monitor where sql_id = '65czba54aqx9f';


select * from gv$sql_monitor where sql_id = 'ad4h7u406jzqs'


Global Stats
=================================================================================
| Elapsed |   Cpu   |    IO    | Application |  Other   | Buffer | Read | Read  |
| Time(s) | Time(s) | Waits(s) |  Waits(s)   | Waits(s) |  Gets  | Reqs | Bytes |
=================================================================================
|      21 |    2.98 |       16 |        0.15 |     2.39 |   312K | 2452 |   2GB |
=================================================================================

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/308563/viewspace-2136320/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-02-17

  • 博文量
    270
  • 访问量
    422291