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]
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/25462274/viewspace-2120566/，如需轉載，請註明出處，否則將追究法律責任。