There is also one called The Big Picture - from Bit by Bit
www.bitbybit.co.uk - that scans all source, and SQL, and stores all
execution plans in a BDE database. It then scans through all the exectution
plans to determine whether an index is used or not.
It doesn't however tell you how many times the index has *actually* been
used..
Mark
-----Original Message-----
Sent: Friday, May 25, 2001 09:18
To: Multiple recipients of list ORACLE-L
There is commercial software for determining this.
www.teleran.com
www.pinecone.com
Both rather spendy.
Jared
On Thursday 24 May 2001 06:10, Wilkes, Steve wrote:
> Hi,
>
> Does anyone know how to determine how many times an index has been used or
> if it has been used at all? I have seen previous attempts by taking
> snapshots of v$sqlarea and then automating an explain plan and extracting
> the information that way. I would have thought that there must be an x$
> table that records this information somewhere?
>
> Any ideas?
>
> Thanks in advance.
>
> Steve Wilkes
> _______________________________
> Oracle DBA
> npower
> email:[EMAIL PROTECTED]
>
> =====================================================================
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> gpupower.co.uk or [EMAIL PROTECTED]
>
> This outgoing e-mail (and any attachments) has been checked
> (using Sophos Sweep 3.45 + patches) before leaving us (UK 08457 353637),
> and has been found to be clean from any virus infection.
>
> =====================================================================
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Mark Leith
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
