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;
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.