| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsfus.sql
{ORACLE_HOME}/rdbms/admin/dbfusrpt.sql |
| First Available |
10.2 |
| Dependencies |
| AWRRPT_HTML_TYPE |
AWRRPT_TEXT_TYPE_TABLE |
|
AWRRPT_HTML_TYPE_TABLE |
DBMS_SWRF_REPORT_INTERNAL |
| AWRRPT_TEXT_TYPE |
PLITBLM |
|
| Security Model |
Execute is granted to the DBA role |
| |
| 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 |
