-
how can I find out how long a query runs
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...
-
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.
-
"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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|