Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

GV$session_longops - Time_Remaining shown as 0

CherrishMar 6 2010 — edited Jan 9 2013
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2013
Added on Mar 6 2010
3 comments
4,237 views