Home » RDBMS Server » Performance Tuning » Measuring time exection
Measuring time exection [message #124445] Sat, 18 June 2005 10:38 Go to next message
Messages: 6
Registered: June 2005
Junior Member
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.
Re: Measuring time exection [message #124449 is a reply to message #124445] Sat, 18 June 2005 11:50 Go to previous messageGo to next message
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

Re: Measuring time exection [message #124562 is a reply to message #124445] Mon, 20 June 2005 04:07 Go to previous message
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?

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

Current Time: Sun Feb 25 22:24:32 CST 2024