I am running parallel insert statement querying data from other tables. The performance is very slow.
The record count is almost 900K
No intermin commit is in place
Parallel Max Server is set to 24
I tried to look into v$session_longops and here is the query and the output which I had received within 5 mnts from the time I started running the insert statement. But the statement is still running.
select * from (select opname, target, sofar, totalwork, units, elapsed_seconds, message from v$session_longops
where sid in(select sid from v$session where username ='Goozy') order by start_time desc)
where rownum <=1;