The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1.
Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs,
and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news.
There is absolutely not a byte of truth to these irresponsible rumors.
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
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);
