**New Oracle dba_feature_usage_statistics View**

June 14, 2004

This news item just-in from Tony Jambu of IOUG:

Are you aware of the following view, DBA_FEATURE_USAGE_STATISTICS? Its function is to display information about database feature usage statistics. 10g will keep track of any of its features that are being used. As an example, if you SELECT from any of the Oracle Diagnostic Pack and Tuning Pack views like V$ACTIVE_SESSION_HISTORY, the database will record your usage of it in this DBA view.

Some of the information tracked are

o       Name of the feature
o       Number of times the system has detected usage for the feature
o       First sample time the system detected usage of the feature
o       Last sample time the system detected usage of the feature

These are just some of the features it tracks

Name - Description
Audit Options - Audit options in use.
Automatic Database Diagnostic Monitor - A task for the Automatic Database Diagnostic Monitor has been executed.
Automatic Segment Space Management (system) - Extents of locally managed tablespaces are managed automatically by Oracle.
Automatic Segment Space Management (user) - Extents of locally managed user tablespaces are managed automatically by Oracle.
Automatic SQL Execution Memory - Sizing of work areas for all dedicated sessions (PGA) is automatic.
Automatic Storage Manager - Automatic Storage Management has been enabled
Automatic Undo Management - Oracle automatically manages undo data using an UNDO tablespace.
Automatic Workload Repository - A manual Automatic Workload Repository (AWR) snapshot was taken in the last sample period.
Change-Aware Incremental Backup - Track blocks that have changed in the database.
Locally Managed Tablespaces (system) - There exists tablespaces that are locally managed in the database.
Locally Managed Tablespaces (user) - There exists user tablespaces that are locally managed in the database.
SQL Access Advisor - A task for SQL Access Advisor has been executed.
SQL Tuning Advisor - SQL Tuning Advisor has been used."

http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10755/statviews_2103.htm#G2023396

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books