SQL Tuning Health-Check Script (SQLHC) Video (Doc ID 1455583.1)

Last updated on NOVEMBER 20, 2023

Applies to:

Details

Ask Questions, Get Help, And Share Your Experiences With This Article

Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?

Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.
Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Tuning.

 

What is the SQL Tuning Health-Check Script?

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. More details about the tool can be found here:

The intention of SQLHC is to allow users to avoid SQL Performance from being affected by avoidable problems by ensuring that the environment that an individual SQL runs in is sound. It does this while leaving "no database footprint" ensuring it can be run on all systems.

When executed for one SQL_ID, this script generates an HTML report with the results of a set of health-checks around the one SQL statement provided.

Discuss SQLHC!

We encourage you to join the discussion by clicking the link below for the entry you would like to provide feedback on. If you have questions or implementation issues with the information in the article above, please share that below.

Still have questions? Consider posting a discussion in the SQLHC Discussion.

Actions

Contacts