SQLHC

SQLHC是一款非常强大的性能分析工具,它是单一SQL级别的,根据我们提供一个SQL_Id来生成HTML报告。

官方介绍
The SQL Tuning Health-Check Script is a tool developed by the Oracle Server Technologies Center of Expertise. The tool, also known as SQLHC, is used to check the environment in which a single SQL Statement runs, checking checks Cost-based Optimizer (CBO) statistics, schema object metadata, configuration parameters and other elements that may influence the performance of the one SQL being analyzed.

参考文档

• SQL Tuning Health-Check Script (SQLHC) [ID 1366133.1]
• FAQ: SQL Health Check (SQLHC) Frequently Asked Questions [ID 1417774.1]

sqlh 下载地址：http://pan.baidu.com/disk/home#list/path=%2Foracle%20tools



http://www.luocs.com/archives/364.html

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

转载于:http://blog.itpub.net/25462274/viewspace-2120566/