| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsfus.sql
{ORACLE_HOME}/rdbms/admin/dbfusrpt.sql |
| First Available |
10.2 |
| Constants |
| Name |
Data Type |
Value |
| DBU_INST_ALWAYS_INSTALLED |
INTEGER |
1 |
| DBU_INST_OBJECT |
INTEGER |
2 |
|
| Dependencies |
dba_feature_usage_statistics
dba_high_water_mark_statistics |
| Object Privileges |
execute on dbms_feature_usage |
| GRANT execute ON dbms_feature_usage TO uwclass; |
| |
| 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: emp\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: emp\usage_report.txt
SELECT output
FROM TABLE(dbms_feature_usage_report.display_text);
spool off |
| |
| Report Demo |
| Using dbfusrpi.sql |
@?
dbms\admin\dbfusrpi |
| Using dbfusrpt.sql |
@?
dbms\admin\dbfusrpt |
Free