I have executed a qurrey i want to see the execution time of that querry can any one help me how to see execution time of a querry
Printable View
I have executed a qurrey i want to see the execution time of that querry can any one help me how to see execution time of a querry
I use a query analyzer called Golden32 from Benthic software. It tells me exactly how long a query took.
In sql*plus try the "set timing" command.
Sometimes using watch is sufficient :D
you write your SQLs in SQL*Plus ?
If I met you in a dark alley.. I'd run the other way.. :D
Oh no, I write them in vi :D, sql*plus is where I test them.Quote:
Originally Posted by cjard