DB version: 11.2.0.4
OS : Oracle Linux 6.5
The following INSERT has been running for the last 7 hours . Usually it finishes in 4 hours. Is there any way to find what percentage of INSERT has completed ?
insert into /*+ APPEND */ Target_table2 select * from LargeQuery;
I tried querying gV$SESSION_LONGOPS WHERE TIME_REMAINING > 0 . But, it didn't return any records.