3 responses

  1. Robin Moffatt
    July 11, 2011

    You can also generate the HTML from the CLI, which may be useful to automating the process for testing etc:

    select
    DBMS_SQLTUNE.REPORT_SQL_MONITOR(
    session_id=>sys_context(‘userenv’,’sid’),type=>’HTML’,
    report_level=>’ALL’,sql_id=>:this_sql_id) as report
    from dual;

    In 11gR1 you only get static HTML, not the fancy Flash stuff.

    Ref: http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_sqltun.htm#sthref8077

    • JeffS
      JeffS
      July 11, 2011

      Knowing how to make the DBMS package calls really opens up a lot of doors for automation. However I find that getting people to recognize and use the tools is a big first hurdle. And after that, maybe 15% of those people take it to the next level with automation. Those 15% are the folks you want working for you though!

      Thanks Robin for the excellent tip and giving us another reason to upgrade to 11gR2!

Leave a Reply

 

 

 

Back to top
mobile desktop