In Oracle Enterprise Manager, Database Feature Usage statistics provide an approximation of how often various database features are used. Tracking this information is useful for application development and for auditing.

To access Database Feature Usage, in Oracle Enterprise Manager, click the Server tab, and then select Database Feature Usage under Database Configuration.

Database Feature Usage captures the following information for Oracle Text:

• Index Usage Statistics: The number of existing indexes in the database for the CONTEXT, CTXCAT, and CTXRULE index types

• SQL Operator Usage Statistics: Whether the user has ever used the CONTAINS, CATSEARCH, and MATCHES operators

• Package Usage Statistics: How often, if ever, and when the following packages were used:

  • CTX_ADM

  • CTX_CLS

  • CTX_DDL

  • CTX_DOC

  • CTX_OUTPUT

  • CTX_QUERY

  • CTX_REPORT

  • CTX_THES

  • CTX_ULEXER