Oracle | DBMS_FEATURE_USAGE

Oracle DBMS_FEATURE_USAGE_REPORT Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Produce feature usage reports in HTML and ASCII formats.

AUTHID DEFINER

Dependencies

AWRRPT_HTML_TYPE	AWRRPT_TEXT_TYPE	DBMS_SWRF_REPORT_INTERNAL
AWRRPT_HTML_TYPE_TABLE	AWRRPT_TEXT_TYPE_TABLE	PLITBLM

Documented No

First Available 10.2

Security Model Owned by SYS with EXECUTE granted to the DBA role

Source {ORACLE_HOME}/rdbms/admin/dbmsfus.sql

Subprograms

DISPLAY_HTML

DISPLAY_TEXT

DISPLAY_HTML

Display Feature Usage Report in HTML Format dbms_feature_usage_report.display_html( l_dbid IN NUMBER DEFAULT NULL, l_version IN VARCHAR2 DEFAULT NULL, l_options IN NUMBER DEFAULT 0) RETURN awrrpt_text_type_table PIPELINED;

spool c:\temp\usage_report.html

      

      SELECT output

      FROM TABLE(dbms_feature_usage_report.display_html);

      

      spool off

DISPLAY_TEXT

Display Feature Usage Report in Text Format dbms_feature_usage_report.display_text( l_dbid IN NUMBER DEFAULT NULL, l_version IN VARCHAR2 DEFAULT NULL, l_options IN NUMBER DEFAULT 0) RETURN awrrpt_html_type_table PIPELINED;

spool c:\temp\usage_report.txt

      

      SELECT output

      FROM TABLE(dbms_feature_usage_report.display_text);

      

      spool off

Report Demo

Using dbfusrpi.sql @?\rdbms\admin\dbfusrpi

Using dbfusrpt.sql @?\rdbms\admin\dbfusrpt