Oracle DBMS_FEATURE_USAGE

Oracle DBMS_FEATURE_USAGE_REPORT Version 11.2.0.3

General Information

AUTHID

DEFINER

Dependencies

AWRRPT_HTML_TYPE	AWRRPT_TEXT_TYPE	DBMS_SWRF_REPORT_INTERNAL
AWRRPT_HTML_TYPE_TABLE	AWRRPT_TEXT_TYPE_TABLE	PLITBLM

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

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