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. |