OraFAQ Forum: Server Administration » How to know wheter index executed, or not ?

Home » RDBMS Server » Server Administration » How to know wheter index executed, or not ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to know wheter index executed, or not ? [message #129258]

Fri, 22 July 2005 15:53

Hina
Messages: 51
Registered: April 2004

Member

Is there a way to see wheter index being executed or not by
query except EXPLAIN PLAN ?

I h've to check at runtime because SELECT is executing by application.

Regards

Report message to a moderator

Re: How to know wheter index executed, or not ? [message #129276 is a reply to message #129258]

Sat, 23 July 2005 01:15

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Hi

Yes U can monitor the usage of index.
For details of process pls visit
http://www.dbazine.com/oracle/or-articles/liu3

Regds
Girish

Report message to a moderator

Re: How to know wheter index executed, or not ? [message #129985 is a reply to message #129276]

Wed, 27 July 2005 10:06

alliejane
Messages: 59
Registered: July 2005
Location: Glasgow

Member

No Message Body

[Updated on: Wed, 27 July 2005 10:48]

Report message to a moderator

Re: How to know wheter index executed, or not ? [message #130105 is a reply to message #129258]

Thu, 28 July 2005 03:33

oraclejo
Messages: 50
Registered: July 2005
Location: Ammar

Member

hello

Run the application

Then identify the SID and SERIAL# of the running session of your application

Then execute the following command

Begin
dbms_system.SET_SQL_TRACE_IN_SESSION(<SID>,<SERIAL#>,TRUE);
END;

the above statement will trace your application, once the application is done

run the follwoing

Begin
dbms_system.SET_SQL_TRACE_IN_SESSION(<SID>,<SERIAL#>,False);
END;

This will end the trace.

find the newly created file in the UDUMP directory

Then ananlyse the file using TKPROF

tkprof tracefile outputfile analyze=scott/tiger

or better look into tkprof to find out what other switches you wnt to use

Ammar Sajdi
www.e-ammar.com

PS
You can use Oracle Enterprise Manager to accomplish the same and READ the execution plan online.. other third party tools accomplish the same

Report message to a moderator

Previous Topic:	ORACLE 8i and 9i features
Next Topic:	Oracle 9i Install on Linux machine

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 26 22:47:11 CDT 2024