Tracking Database Feature Usage in Oracle Enterprise Manager

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

Note: The feature usage tracking statistics might not be 100 percent accurate.