Check Usage

SET PAGESIZE 200

SET LINESIZE 200

SELECT i.instance_name,

       u.name AS feature_name,

       u.last_usage_date 

  FROM dba_feature_usage_statistics u,

       v$instance i

 WHERE detected_usages > 0

 ORDER BY 1;

For more detailed analysis use the script provided in Oracle Support Note: 1317265.1

By default DBA_FEATURE_USAGE_STATISTICS is updated about once per week (1). You can force a refresh using...

EXEC DBMS_FEATURE_USAGE_INTERNAL.exec_db_usage_sampling(SYSDATE);

Check Component Status

SET linesize 200

SET pagesize 40

COLUMN schema FORMAT a20

COLUMN comp_id FORMAT a15

COLUMN comp_name FORMAT a40

SELECT comp_id, comp_name, version, status, schema

FROM dba_registry;

Tools

Features

Options

Use the chopt tool after installation to add or remove Oracle Database options.

Packs

Coding

Bibliography & References