I am familiar with running various queries based on v$session, v$sql, V$SESSION_LONGOPS, etc
However have a merge statement (running via odi) which is inserting/updating a very large partitioned table. (hundreds of millions of rows).
I was wondering if anyone knew how I could query how many rows are affected in each partition of the large table. (while the long running query is still running and not yet commit'ed)
I welcome feedback/direction.
I suspect the answer would be NO, since the transaction is still running and not committed.