OraFAQ Forum: Performance Tuning » Measuring time exection

Home » RDBMS Server » Performance Tuning » Measuring time exection

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

Measuring time exection [message #124445]

Sat, 18 June 2005 10:38

jef1
Messages: 6
Registered: June 2005

Junior Member

Hello,
I would like to know how i can get the time taken by a query or a stored procedure to execute.
What are the possiblities to do that ?
Thanks a lot.

Report message to a moderator

Re: Measuring time exection [message #124449 is a reply to message #124445]

Sat, 18 June 2005 11:50

pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville

Senior Member

I used a test harness by Oracle guru Tom Kyte, freely available from here. Use runstats.sq

More detail in the following link
http://asktom.oracle.com/~tkyte/runstats.html

Ravi

Report message to a moderator

Re: Measuring time exection [message #124562 is a reply to message #124445]

Mon, 20 June 2005 04:07

limer
Messages: 15
Registered: June 2005
Location: Madrid

Junior Member

If you are using SQL plus you can activate timing

Set timing on

very easy ok?

Report message to a moderator

Previous Topic:	choosing the right query
Next Topic:	Reg. Performance Issue with XML

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 24 05:35:12 CDT 2025