how can I find out how long a query runs with no tkprof or traces. just from v$ tables.
oracle db 9.2.0.3
Thanks...
:confused:
Printable View
how can I find out how long a query runs with no tkprof or traces. just from v$ tables.
oracle db 9.2.0.3
Thanks...
:confused:
select to_char(sysdate,'dd-mon-yy hh24:mi:ss') from dual;
sqlstatement;
select to_char(sysdate,'dd-mon-yy hh24:mi:ss') from dual;
look at difference or ...
dbms_utility.get_time();
HTH
Gregg
No need to look at v$table.
set time on
set timing on
Set autot trace statis
and run your sql statement.
You will see the elpased time.
Tamil
"set timing on" will work only in sqlplus.
you can look in v$session_longops view.
Thank,
its been very helpfull.
If the trnsaction is over you won't get any information from v$session_longops view. The above is true if you can do baby sitting by watching the running transaction. BTW If you can do the baby sitting then you even don't need v$ view, put the clock in front of you.Quote:
"set timing on" will work only in sqlplus.
you can look in v$session_longops view.