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: how do i know if an index is being/ever used ?

Re: how do i know if an index is being/ever used ?

From: Sheilah Scheurich <scheuric_at_sprynet.com>
Date: 1997/05/01
Message-ID: <33681f15.5436915@news.interserv.com>#1/1

On 30 Apr 1997 13:36:50 GMT, "Engenoil" <engenoil_at_iafrica.com> wrote:

>hello all,
>does oracle have the ability to determine whether or not an index is / has
>been used ?
>how do dba's know if they are maintaining 100's of useless indexes ? (we've
>inherited, heh-heh)
>thank you all in advance.
>daryl & bruno

look at the statements being run in TKPROF. Alter session set sql_trace true;

You can also use a stored procedure.
EXECUTE sys.RDBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(A,B,TRUE);

sheilah scheurich
scheuric_at_sprynet.com Received on Thu May 01 1997 - 00:00:00 CDT

Original text of this message

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