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. |