DBA_FEATURE_USAGE_STATISTICS

DBA_FEATURE_USAGE_STATISTICS displays information about database feature usage statistics.

Column	Datatype	NULL	Description
DBID	NUMBER	NOT NULL	Database identifier of the database being tracked
NAME	VARCHAR2(64)	NOT NULL	Name of the feature (see Table 4-1)
VERSION	VARCHAR2(17)	NOT NULL	Database version in which the feature was tracked
DETECTED_USAGES	NUMBER	NOT NULL	Number of times the system has detected usage for the feature
TOTAL_SAMPLES	NUMBER	NOT NULL	Number of times the system has woken up and checked for feature usage
CURRENTLY_USED	VARCHAR2(5)		Indicates whether usage was detected the last time the system checked (TRUE) or not (FALSE)
FIRST_USAGE_DATE	DATE		First sample time the system detected usage of the feature
LAST_USAGE_DATE	DATE		Last sample time the system detected usage of the feature
AUX_COUNT	NUMBER		This column stores feature-specific usage data in number format.
FEATURE_INFO	CLOB		This column stores feature-specific usage data in character format.
LAST_SAMPLE_DATE	DATE		Amount of time (in seconds) between the last two usage sample times
LAST_SAMPLE_PERIOD	NUMBER		Amount of time (in hours) between the last two usage sample times
SAMPLE_INTERVAL	NUMBER		Sample interval
DESCRIPTION	VARCHAR2(128)		Description of the feature and usage detection logic (see Table 4-1)

Table 4-1 DBA_FEATURE_USAGE_STATISTICS Statistics

Name	Description
Undo Advisor	Undo Advisor has been used.
SQL Tuning Advisor	SQL Tuning Advisor has been used.
Segment Advisor	Segment Advisor has been used.
SQL Workload Manager	SQL Workload Manager has been used.
Tune MView	Tune MView has been used.
SQL Performance Impact	SQL Performance Impact has been used.
SQL Repair Advisor	SQL Repair Advisor has been used.
SQL Tuning Set (user)	A SQL Tuning Set has been created in the database in a user schema.
SQL Tuning Set (system)	A SQL Tuning Set has been created in the database in the SYS schema.
Automatic SQL Tuning Advisor	Automatic SQL Tuning Advisor has been used.
SQL Profile	SQL profiles have been used.
Database Replay: Workload Capture	Database Replay: Workload was ever captured.
Database Replay: Workload Replay	Database Replay: Workload was ever replayed.
Streams (system)	Oracle Streams processes have been configured
Streams (user)	Users have configured Oracle Streams AQ
Transparent Gateway	Heterogeneous Connectivity, access to a non-Oracle system, has been configured.
Virtual Private Database (VPD)	Virtual Private Database (VPD) policies are being used.
Workspace Manager	There is at least one version enabled table.
XDB	XDB feature is being used.
Application Express	Application Express feature is being used.
LOB	Persistent LOBs are being used.
Object	Object feature is being used.
Extensibility	Extensibility feature is being used.
SQL Plan Management	SQL Plan Management has been used.
Rules Manager	Rules Manager and Expression Filter
Oracle Utility Datapump (Export)	Oracle Utility Datapump (Export) has been used.
Oracle Utility Datapump (Import)	Oracle Utility Datapump (Import) has been used.
Result Cache	The Result Cache feature has been used.
Oracle Utility SQL Loader (Direct Path Load)	Oracle Utility SQL Loader (Direct Path Load) has been used.
Oracle Utility Metadata API	Oracle Utility (Metadata API) has been used.
Transparent Data Encryption	Transparent Database Encryption is being used. There is atleast one column or tablespace that is encrypted.
interMedia	interMedia has been used
interMedia DICOM	interMedia DICOM has been used
Materialized Views (User)	User Materialized Views exist in the database
Change Data Capture	Change Data Capture exit in the database
Services	Oracle Services.
Semantics/RDF	A semantic network has been created indicating usage of the Oracle Semantics Feature.
SecureFiles	SecureFiles are being used
Automatic Segment Advisor	Automatic Segment Advisor has been used.
Segment Shrink	Segment Shrink has been used.
Advanced Replication	Advanced Replication has been enabled.
Advanced Security	External Global users are configured.
Audit Options	Audit options in use.
Automatic Maintenance - Optimizer Statistics Gathering	Automatic initiation of Optimizer Statistics Collection
Automatic Maintenance - Space Advisor	Automatic initiation of Space Advisor
Automatic Maintenance - SQL Tuning Advisor	Automatic initiation of SQL Tuning Advisor
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.
AWR Baseline	At least one AWR Baseline has been created by the user
AWR Baseline Template	At least one AWR Baseline Template has been created by the user
Backup Encryption	Encrypted backups are being used.
Baseline Adaptive Thresholds	Adaptive Thresholds have been configured.
Baseline Static Computations	Static baseline statistics have been computed.
Change-Aware Incremental Backup	Track blocks that have changed in the database.
Client Identifier	Application User Proxy Authentication: Client Identifier is used at this specific time.
Clusterwide Global Transactions	Clusterwide Global Transactions is being used.
CSSCAN	Oracle Database has been scanned at least once for character set:CSSCAN has been run at least once.
Character Semantics	Character length semantics is used in Oracle Database
Character Set	Character set is used in Oracle Database
Data Guard	Data Guard, a set of services, is being used to create, maintain, manage, and monitor one or more standby databases.
Data Mining	There exist Oracle Data Mining models in the database.
Dynamic SGA	The Oracle SGA has been dynamically resized through an ALTER SYSTEM SET statement.
EM Database Control	EM Database Control Home Page has been visited at least once.
EM Grid Control	EM Grid Control Database Home Page has been visited at least once.
File Mapping	File Mapping, the mechanism that shows a complete mapping of a file to logical volumes and physical devices, is being used.
Flashback Database	Flashback Database, a rewind button for the database, is enabled
Flashback Data Archive	Flashback Data Archive, a historical repository of changes to data contained in a table, is used
Internode Parallel Execution	Internode Parallel Execution is being used.
Label Security	Oracle Label Security, that enables label-based access control Oracle applications, is being used.
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.
Messaging Gateway	Messaging Gateway, that enables communication between non-Oracle messaging systems and Advanced Queuing (AQ), link configured.
Very Large Memory	Very Large Memory is enabled.
Automatic Memory Tuning	Automatic Memory Tuning is enabled.
Automatic SGA Tuning	Automatic SGA Tuning is enabled.
Encrypted Tablespaces	Encrypted Tablespaces is enabled.
MTTR Advisor	Mean Time to Recover Advisor is enabled.
Multiple Block Sizes	Multiple Block Sizes are being used with this database.
OLAP - Analytic Workspaces	OLAP - the analytic workspaces stored in the database.
OLAP - Cubes	OLAP - number of cubes in the OLAP catalog that are fully mapped and accessible by the OLAP API.
Oracle Managed Files	Database files are being managed by Oracle.
Oracle Secure Backup	Oracle Secure Backup is used for backups to tertiary storage.
Parallel SQL DDL Execution	Parallel SQL DDL Execution is being used.
Parallel SQL DML Execution	Parallel SQL DML Execution is being used.
Parallel SQL Query Execution	Parallel SQL Query Execution is being used.
Partitioning (system)	Oracle Partitioning option is being used - there is at least one partitioned object created.
Partitioning (user)	Oracle Partitioning option is being used - there is at least one user partitioned object created.
Oracle Text	Oracle Text is being used - there is at least one oracle text index
PL/SQL Native Compilation	PL/SQL Native Compilation is being used - there is at least one natively compiled PL/SQL library unit in the database.
Real Application Clusters (RAC)	Real Application Clusters (RAC) is configured.
Recovery Area	The recovery area is configured.
Recovery Manager (RMAN)	Recovery Manager (RMAN) is being used to backup the database.
RMAN - Disk Backup	Recovery Manager (RMAN) is being used to backup the database to disk.
RMAN - Tape Backup	Recovery Manager (RMAN) is being used to backup the database to tape.
Block Media Recovery	Block Media Recovery is being used to repair the database.
Restore Point	Restore Points are being used as targets for Flashback
Logfile Multiplexing	Multiple members are used in a single log file group
Bigfile Tablespace	Bigfile tablespace is being used
Transportable Tablespace	Transportable tablespace is being used
Read Only Tablespace	Read only tablespace is being used
Deferred Open Read Only	Deferred open read only feature is enabled
Physical Standby with Real-Time Query	Physical standby database is in real-time query mode
Backup Rollforward	Backup Rollforward strategy is being used to backup the database.
Data Recovery Advisor	Data Recovery Advisor (DRA) is being used to repair the database.
Resource Manager	Oracle Database Resource Manager is being used to manage database resources.
Server Parameter File	The server parameter file (SPFILE) was used to startup the database.
Shared Server	The database is configured as Shared Server, where one server process can service multiple client programs.
Spatial	There is at least one usage of the Oracle Spatial index metadata table.
ADDM	ADDM has been used.
SQL Access Advisor	SQL Access Advisor has been used.