生成sql monitor active report脚本

点击(此处)折叠或打开

1. set long 1000000
   
2. set longchunksize 1000000
   
3. set linesize 1000
   
4. set pagesize 0
   
5. set trim on
   
6. set trimspool on
   
7. set echo off
   
8. set feedback off
   
9. 
   
10. spool report_sql_monitor.html
    
11. 
    
12. SELECT dbms_sqltune.report_sql_monitor(sql_id => \'0tm6yzkgzrfdn\',
    
13.                                        base_path => \'http://www.eygle.com/sqlmon\',
    
14.                                        report_level =>\'ALL\',
    
15.                                        TYPE =>\'ACTIVE\')
    
16.   FROM dual;
    
17.   
    
18.   
    
19. spool off

执行后得到的效果截图

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

转载于:http://blog.itpub.net/8520577/viewspace-1259983/