This content has been marked as final. Show 2 replies
You can use the v$session_longops fixed view. Here is a simple example;
Hope it Helps,
First session; SQL> select a.sql_id, b.sql_text, opname, target, username, sofar, totalwork from v$session_longops a, v$sql b where username='OGAN' and a.sql_id = b.sql_id; SQL_ID SQL_TEXT OPNAME TARGET USERNAME SOFAR TOTALWORK ---------------- Table Scan OGAN.OGAN_DENEME OGAN 4379 78893 1bmg9nrw5udjx delete ogan_deneme Second session; SQL> delete ogan_deneme;
Edited by: Ogan Ozdogan on 12.Tem.2010 17:11
Also you can convert the sofar and totalwork to a time value and/or percentage completed parameter. You will have to modify my SQL in order to do that.