select query [message #276531] |
Thu, 25 October 2007 07:38  |
balajisundar
Messages: 29 Registered: October 2007
|
Junior Member |
|
|
Hi,
Can any body let me know how to find out the time consumed by a select query...? This query would probably fetch more than 100 thousand records in a table.
Thanks
Balaji
|
|
|
|
Re: select query [message #276535 is a reply to message #276531] |
Thu, 25 October 2007 07:49   |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
You probably have to be more specific what you mean by how much time (cpu time, clock time, etc.), but do a SET TIMING ON then run your query and tell if that's what you want.
|
|
|
Re: select query [message #276539 is a reply to message #276531] |
Thu, 25 October 2007 07:53   |
Cthulhu
Messages: 381 Registered: September 2006 Location: UK
|
Senior Member |
|
|
I usually use:
set autotrace trace stat
set timing on
then run the query. It stops any output reaching the screen and gives you the time taken to run the query + execution stats.
[Updated on: Thu, 25 October 2007 07:53] Report message to a moderator
|
|
|
Re: select query [message #276545 is a reply to message #276531] |
Thu, 25 October 2007 08:13  |
balajisundar
Messages: 29 Registered: October 2007
|
Junior Member |
|
|
Hi All,
Thank You so much. This is my first question to the Forum and i got the solution.
SET TIMING ON is what i was looking out for and it solved my need.
As well Iam using Oracle SQL Developer to execute the SQL part and by default it provides the time taken for each query that is executed.
Regards,
Balaji
|
|
|