How to Identify the current step in execution
437729Mar 10 2008 — edited Mar 10 2008Hi,
My merge query takes a long time to run. I monitored the session and it was doing a full table scan and it registered as a long-operation. Now thats finished and it goes off to do whatever else it needs to do.
How do I know whats its executing at any given point in time? I want to know what it scans / writes next and what object its scanning. In other words, I want to know which step of the execution plan is it currently executing.
Is there a way of identifying this? Any V$ views which provide this information?
Thanks in advance,
K