Plsql_plsql Tuning Health Check Script SQLHC (case) (Output SQL performance HTML report by running script)

2014-08-23 Baoxinjian

I. Summary

A script that is circulated online to query the efficiency of a single SQL query and export it as an HTML report, similar in function to Dbms_profiler

Query sql_id by session, only run script, export as HTML report

The SQL script: Http://files.cnblogs.com/eastsea/sqlcheck.zip

Ii. cases-Using the script data SQL performance HTML report

1. Enter the SQL you want to query

2. Uploading Scripts

3. Query parameter sql_id

4. Invoking the script and outputting it as an HTML report

5. Viewing HTML reports

Abalone New ********************

Reference: http://www.askmaclean.com/archives/sql-tuning-health-check-script.html

Reference:https://support.oracle.com/epmos/faces/documentdisplay?_afrloop=2065290088690137&id=243755.1& displayindex=1&_afrwindowmode=0&_adf.ctrl-state=ni8g1bex6_126

Plsql_plsql Tuning Health Check Script SQLHC (case) (Output SQL performance HTML report by running script)