PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)

2014-08-23 Created By BaoXinjian

PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)


网上流传的一个用以查询单一SQL查询的效率并导出为HTML报表的脚本,功能与DBMS_PROFILER类似

通过session查询SQL_ID,只有运行脚本,导出为HTML报表

该SQL脚本下载地址:http://files.cnblogs.com/eastsea/sqlcheck.zip

PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)二、案例 - 使用该脚本数据SQL Performance HTML报表


1. 输入需查询SQL

PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)

2. 上传脚本

PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)

3. 查询参数SQL_ID

PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)

4. 调用脚本,并输出为HTML报表

PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)

5. 查看HTML报表

PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)

PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)

PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)

PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)

PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)

PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)

PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)

PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)

Thanks and Regards

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

PLSQL_性能优化工具系列02_SQL Tuning Health-Check Script (SQLHC)

上一篇:SpringCloud微服务框架


下一篇:WIFI物联网平台微信端开发分享