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

Home -> Community -> Usenet -> c.d.o.server -> Re: IDing unsed indexes?

Re: IDing unsed indexes?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 24 Nov 1999 20:49:13 +0800
Message-ID: <383BDEC9.1B15@yahoo.com>


James Lorenzen wrote:
>
> I am supporting a PeopleSoft application (AP & GL). There are a large
> number of indexes that have been added for "performance" purposes, I
> would like to have some method to help monitor what indexes are used.
> The database instance is set for CHOOSE and we calculate the statistics
> weekly for the tables.
>
> I saw a reference to X$BH table that might help identify the indexes
> that are used. (I would need to monitor this and capture what was found
> in the buffer over time.)
>
> I would like to minimize the number of indexes that are there and remove
> those that are not used.
>
> Is there some documentation on the X$ tables, or some other technique
> (other than tracing all jobs) that would help monitor the index usage.
>
> TIA
> James
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

You can join X$BH to OBJ$ to get names of indexes (type=1)

HTH
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Nov 24 1999 - 06:49:13 CST

Original text of this message

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