PDA

Click to See Complete Forum and Search --> : Execution time

msurendra_rao
03-26-2007, 07:06 AM
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
cjard
03-26-2007, 07:23 AM
I use a query analyzer called Golden32 from Benthic software. It tells me exactly how long a query took.
ales
03-26-2007, 08:18 AM
In sql*plus try the "set timing" command.
Sometimes using watch is sufficient :D
cjard
03-26-2007, 11:09 AM
you write your SQLs in SQL*Plus ?

If I met you in a dark alley.. I'd run the other way.. :D
ales
03-27-2007, 05:09 AM
you write your SQLs in SQL*Plus ?
Oh no, I write them in vi :D, sql*plus is where I test them.