Thursday, August 2, 2012

Generate monitoring scripts for all indexes

select 'alter index '||index_name||' monitoring usage' from user_indexes where
      index_type=’NORMAL’;

No comments:

Post a Comment