hcheck.sql - Script to Check for Known Problems in Oracle8i, Oracle9i, Oracle10g, Oracle 11g and Oracle 12c and Above
(Doc ID 136697.1)
Last updated on OCTOBER 22, 2020
Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Backup Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Oracle Database Cloud Service - Version N/A and later Oracle Database Cloud Schema Service - Version N/A and later Information in this document applies to any platform.
To provide a single package which looks for common Data Dictionary problems.
The script checks consistency of selected dictionary relationships and looks for certain known issues - some reported "problems" will be normal and expected.
The script can be used with Oracle Release 9i onwards. hcheck8i.sql includes 8.1.
It is a lightweight "read-only" script with no impact.
The script is for use mainly under the guidance of Oracle Support.
For Oracle 10.2.0.5 onwards, use version 07MAY18 in file hcheck.sql