CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_FEATURE_USAGE_REPORT

Version 11.1
 
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
 
Related Topics
AWR Report
DBMS_FEATURE_USAGE
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [35 users online]    © 2010 psoug.org