RE: Index Usage Monitoring

From: <exu_at_nnng.com>
Date: Mon, 05 Feb 2001 13:17:29 -0800
Message-ID: <F001.002AAF3D.20010205105635@fatcity.com>

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

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:
  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

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). Received on Mon Feb 05 2001 - 15:17:29 CST