Wednesday, November 10, 2010

Database usage

Database feature usage report 

Method 1
1. Login to oem
2. Select database
3. Select server tab
4. Select database Feature Usage View

Method 2
1. sqlplus as system
2. execute following sql statement
SELECT output
FROM TABLE(dbms_feature_usage_report.display_text);


Hope this helps. Regards Rupam