Home » RDBMS Server » Performance Tuning » Measuring time exection
Measuring time exection [message #124445] Sat, 18 June 2005 10:38 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 17 13:35:53 CST 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.