RE: Index Usage Monitoring

From: Vadim Gorbounov <vgorbounov_at_simplyengineering.com>
Date: Mon, 05 Feb 2001 10:08:18 -0800
Message-ID: <F001.002AAA06.20010205073047@fatcity.com>

        Hi, 
        Why not to use otrace? Of cource, you may need some space to save

trace results, but you'll definitely get complete statistics.

        Vadim Gorbounov
        Oracle DBA

-----Original Message-----
Sent: Tuesday, January 30, 2001 3:57 PM
To: Multiple recipients of list ORACLE-L

We have a purchased application with over 1,300 indexes.

Can someone suggest a method to monitor the system to determine which indexes are actively being used over time? I'm assuming that some are old/not necessary and would like to save the overhead of maintaining them.

Oracle 8.0.6

 Patrick Prince                               email: pprince_at_oppd.com 
 Omaha Public Power District               voice: (402) 636-3762

444 S 16th St. Mall, Omaha, NE 68102 fax: (402) 636-3931

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: PRINCE, PATRICK W.
INET: pprince_at_oppd.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Vadim Gorbounov
INET: vgorbounov_at_simplyengineering.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------