The DBMS_SQLDIAG package provides APIs to diagnose SQL statements. It is used by diagnostic modules including SQL_TESTCASE and SQL_DIAGNOSTIC.
Subroutines include:
The package is defined in $ORACLE_HOME/rdbms/admin/dbmsdiag.sql