Oracle | DBMS_FEATURE_USAGE

Oracle DBMS_FEATURE_USAGE_REPORT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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 /u01/home/oracle/reports/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 /u01/home/oracle/reports/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