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 |
|---|---|
|
Advanced Replication |
Advanced Replication has been enabled. |
|
Advanced Security |
External Global users are configured. |
|
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. |
|
Client Identifier |
Application User Proxy Authentication: Client Identifier is used at this specific time. |
|
Data Guard |
Data Guard, a set of services, is being used to create, maintain, manage, and monitor one or more standby databases. |
|
Data Guard Broker |
Data Guard Broker, the framework that handles the creation maintenance, and monitoring of Data Guard, is being used |
|
Data Mining |
Oracle Data Mining option is being used. |
|
Dynamic SGA |
The Oracle SGA has been dynamically resized through an ALTER SYSTEM SET statement. |
|
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 |
|
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. |
|
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. |
|
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. |
|
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. |
|
Protection Mode - Maximum Availability |
Data Guard configuration data protection mode is Maximum Availability. |
|
Protection Mode - Maximum Performance |
Data Guard configuration data protection mode is Maximum Performance. |
|
Protection Mode - Maximum Protection |
Data Guard configuration data protection mode is Maximum Protection. |
|
Protection Mode - Unprotected |
Data Guard configuration data protection mode is Unprotected. |
|
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. |
|
Resource Manager |
Oracle Database Resource Manager is being used to control database resources. |
|
Segment Advisor |
A task for Segment Advisor has been executed. |
|
Server Parameter File |
The server parameter file (SPFILE) was used to startup the database. |
|
SGA/Memory Advisor |
SGA/Memory Advisor has been used. |
|
Shared Server |
The database is configured as Shared Server, where the server process can service multiple user processes. |
|
Spatial |
There is at least one usage of the Oracle Spatial index metadata table. |
|
SQL Access Advisor |
A task for SQL Access Advisor has been executed. |
|
SQL Tuning Advisor |
SQL Tuning Advisor has been used. |
|
SQL Tuning Set |
A SQL Tuning Set has been created in the database. |
|
Standby Archival - LGWR |
Data Guard configuration: Remote archival is done by LGWR. |
|
Standby Archival - ARCH |
Data Guard configuration: Remote archival is done by ARCH. |
|
Standby Transmission |
Standby database: Network transmission mode was chosen for a standby destination. |
|
Streams (system) |
Oracle Streams has been configured |
|
Streams (user) |
Users have configured Oracle Streams |
|
Tablespace Advisor |
Tablespace Advisor has been used. |
|
Transparent Gateway |
Heterogeneous Connectivity, access to a non-Oracle system, has been configured. |
|
Undo Advisor |
Undo Advisor has been used. |
|
Virtual Private Database (VPD) |
Virtual Private Database (VPD) policies are being used. |