I used this:

select * from gv$session_longops where sofar!=totalwork;

I also used other variations of this view but could not find what I required.

It's a 2 node RAC and database is in NORACHIVELOG mode. I am wondering whether the operations such as direct load insert and merge are logged in v$session_longops when the database is in NOARCHIVELOG mode.