Oracle 18cR3 DBMS_FEATURE_USAGE

Oracle DBMS_FEATURE_USAGE_REPORT Version 18.3.0.1

General Information

Library Note

Morgan's Library Page Header

Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.

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.0.1

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