Friday, January 15, 2010

Auditing feature usage in Oracle

select name, detected_usages from dba_feature_usage_statistics where dbid = (select dbid from v$database) and version = '10.2.0.4.0';

select name, highwater from dba_high_water_mark_statistics where dbid = (select dbid from v$database) and version = '10.2.0.4.0';