Re: How many times has an index been used?

That is clever Steve.

I'm gonna go play now. :)

Jared

On Tuesday 29 May 2001 07:00, Steve Adams wrote:
> Hi All,
>
> A cheaper solution to this is to use an AFTER LOGON trigger to set
> CREATE_STORED_OUTLINES to true. If the users have the CREATE ANY OUTLINE
> system privilege, you'll be able to see which indexes are being used in the
> DBA_OUTLINE_HINTS view.
>
> @ Regards,
> @ Steve Adams
> @ http://www.ixora.com.au/
> @ http://www.christianity.net.au/
>
>
> -----Original Message-----
> Sent: Tuesday, 29 May 2001 19:55
> To: Multiple recipients of list ORACLE-L
>
>
> 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:steve.wilkes_at_npower.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).