Estimated time to complete the job
417430Jan 6 2010 — edited Jan 6 2010Here is my db version i am using...
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
My user is runing one report and they are asking me how long it is going to take to complete...
1 select
2 cpu_time/1000000,
3 elapsed_time/1000000
4 from
5 v$session a,
6 v$sqlarea b,
7 v$sess_io c
8 where
9 a.sql_hash_value = b.hash_value
10 and a.sql_address = b.address
11 and a.sid = c.sid
12 and a.username is not null
13 and machine='antuser'
14* and username='REPORT'
SQL> /
CPU_TIME/1000000 ELAPSED_TIME/1000000
---------------- --------------------
355.577944 3883.35267
Based on this output, can i say, ELAPSED_TIME is estimated time to complete? If so, this is Minute or seconds?
Please let me know