RE: Index Usage Monitoring

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Mon, 05 Feb 2001 14:09:56 -0800
Message-ID: <F001.002AB396.20010205134243@fatcity.com>

The issue with a lot of these ways of monitoring indexes that are not used is that there *could* be indexes in place that are soley there for something like a year/month end report.. And you just might not catch that when monitoring for a couple of months, drop the index, and get stung muchos when your user fires off that all damaging report..

-----Original Message-----

exu_at_nnng.com
Sent: Monday, February 05, 2001 06:57
To: Multiple recipients of list ORACLE-L

I do know there is a way to tell which indexes are accessed most recently by query x$bh view. Is this what you want or something different? Sorry I forgot
the initial posting of this issue.

Eveleen

Please respond to ORACLE-L_at_fatcity.com

Vadim Gorbounov <vgorbounov_at_simplyengineering.com> on 02/05/2001 09:30:47 AM

Message - From: Vadim Gorbounov <vgorbounov_at_simplyengineering.com> on 02/05/2001 03:30 PM GMT

 To:      Multiple recipients of list ORACLE-L
          <ORACLE-L_at_fatcity.com>

 cc:      (bcc: Eveleen Xu/NNIB/NNNG)

Subject: RE: Index Usage Monitoring

     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


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

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

Author:
INET: exu_at_nnng.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

--

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

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

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