$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print <<

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:\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
  EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>