how can I find out how long a query runs

[liorjsb]

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...

[gbrabham]

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

[tamilselvan]

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

[rajabalachandra]

"set timing on" will work only in sqlplus.

you can look in v$session_longops view.

[liorjsb]

Thank,
its been very helpfull.

[bhallar]

"set timing on" will work only in sqlplus.

you can look in v$session_longops view.

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.