Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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

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.