I have a time consuming query which populates a materialized view. It has been running for 18 hours - which was not expected.
SELECT STATUS FROM V$SESSION WHERE SID=194;
The above query shows the session as 'ACTIVE'. I was wondering if that is sufficient proof that the query is still running and whether there is any other way to double check that the session is not dead.
The session was not dead; but there was a constant wait:
SQL*Net more data from dblink
I used sql trace as suggested by Phil to reach this conclusion.