• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How to check which options or features are used in the Oracle database

by admin

This post explains how you can check which options or features are used in the database. This is particularly useful for licensing purposes or when you want to de-install a certain option.

This can be achieved through the DBA_FEATURE_USAGE_STATISTICS view. This view will list the feature usage on a per patchset basis. So the combination of feature name and version is unique.

Typically one can verify the features used using the following query:

select * 
from DBA_FEATURE_USAGE_STATISTICS
where detected_usages > 0
order by name, version;

To get a list of options that are not in use:

select * 
from DBA_FEATURE_USAGE_STATISTICS 
where detected_usages = 0
order by name, version;
Note: If the DBID has been changed via nid command, the query against the DBFUS view MUST include the current DBID otherwise the results returned will be incorrect.

Filed Under: oracle

Some more articles you might also be interested in …

  1. How to Find the SQL_ID for a SQL statement or PL/SQL block
  2. How to Use DBMS_METADATA To Get The DDL For Objects
  3. How to Start and Stop OSWatcher
  4. Oracle Database : script to create a “CREATE SYNONYM Script”
  5. How to change max_string_size value from STANDARD to EXTENDED
  6. PL/SQL Cursor Variables with REF CURSOR
  7. Understanding the Global Resource Management Concepts in Oracle RAC
  8. Beginners Guide to Monitoring Oracle Database Restore/Recovery Progress
  9. How to Configure client connectivity in Oracle Data Guard configuration (Implement failover procedures)
  10. How to duplicate a Oracle Database to a previous Incarnation

You May Also Like

Primary Sidebar

Recent Posts

  • vgextend Command Examples in Linux
  • setpci command – configure PCI device
  • db_load command – generate db database
  • bsdtar command – Read and write tape archive files

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright