My Oracle Support Banner

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

Last updated on NOVEMBER 20, 2023

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database - Personal Edition - Version and later
Oracle Database - Enterprise Edition - Version and later
Oracle Database - Standard Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.








NOTE: Some users have reported issues with the video failing to play in the Firefox and Chrome Browsers.
If the video below fails to play, please try a different browser - for example the video plays successfully in Internet Explorer.

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:

<Document 1366133.1> SQL Tuning Health-Check Script (SQLHC)
<Document 1417774.1> FAQ: SQLHC HealthCheck Frequently Asked Questions

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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.