ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Produce feature usage reports in HTML and ASCII formats.
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);
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);