Oracle DBMS_FEATURE_USAGE_REPORT
Version 18.1.0.0

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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 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

Related Topics
AWR Report
DBMS_FEATURE_USAGE
DBMS_FEATURE_USAGE_INTERNAL
Feature Usage Procedures
Packages
What's New In 12cR2
What's New In 18cR1

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved