Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 
 

dba_feature_usage_statistic  Tips

Oracle Tips by Burleson Consulting

April 22, 2013

Question:  When getting a license audit by Oracle how do they tell what features that I have used.  Do they use the dba_feature_usage_statistics view?

Answer:  Oracle will keep track of any of its features that are being used.   An Oracle license audit is very scary and the dba_feature_usage_statistics purpose is to audit what features you have enabled and used.

It's function is to display information about database feature usage statistics. 

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

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

According to Oracle Corporation, these are just some of the features it tracks
    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.


 


 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational

 

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster