Description of Procedures in CTX_REPORT

The CTX_REPORT package contains the following procedures:

Name Description
DESCRIBE_INDEX Creates a report describing the index.
DESCRIBE_POLICY Creates a report describing a policy.
CREATE_INDEX_SCRIPT Creates a SQL*Plus script to duplicate the named index.
CREATE_POLICY_SCRIPT Creates a SQL*Plus script to duplicate the named policy.
INDEX_SIZE Creates a report to show the internal objects of an index, their tablespaces and used sizes.
INDEX_STATS Creates a report to show the various statistics of an index.
QUERY_LOG_SUMMARY Creates a report showing query statistics
TOKEN_INFO Creates a report showing the information for a token, decoded.
TOKEN_TYPE Translates a name and returns a numeric token type.
VALIDATE_INDEX Checks for index corruption and reports on problems found. Mainly used with Oracle Support.