Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Index monitoring and analyzing indexes - best solution?

Index monitoring and analyzing indexes - best solution?

From: <Jay.Miller_at_tdameritrade.com>
Date: Wed, 21 Feb 2007 12:17:35 -0500
Message-ID: <304CF4722010DD4FA19829D09DDB956B21D592@prdhswsemlmb01.prod-am.ameritrade.com>


I was about to write a script to load information on any unused indexes to a table, then another to drop index monitoring and then reenable it. I figured I'd run the first just before gathering stale stats and the other just after gathering stale stats.  

Before doing that I was wondering if anyone had a better way to handle this or had an existing script to do the same thing?    

For anyone wondering what I'm talking about gathering stats on an index marks it as used. Really annoying.  

Jay Miller     

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 21 2007 - 11:17:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US