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

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