GV$session_longops - Time_Remaining shown as 0
Hi,
I have a query joining 4 tables and it returns 48 million. I have used /+parallel(tablename,4) */ hint with the select clause. I want to the 48 million returned by the query to another table t2.
I do get the select result in 20 minutes. when I am performing insert, I checked gv$session_longops. I usually check like select * from gv$session_longops where time_remaining>0.(http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:30141363147028) .
It didnt return anything. I removed the where clause and rather gave the sid.(i found the sql_id from gv$session)
select * from gv$session_longops where sql_id='XXXXXXX';
I got 3 rows but time_remaining column is 0. Could someone explain why this is so.
OS: Linux
DB:11.1.0.6.0 - 11g
Rac- 2 node RAC
Thanks
Cherrish Vaidiyan