Query to find the execution plan of a session.
SELECT operation, options, object_name, DEPTH, ID, COST
FROM v$sql_plan
WHERE hash_value IN (SELECT hash_value
FROM v$sql
WHERE address IN (SELECT sql_address FROM v$session WHERE SID = &SID))
AND object_name IS NOT NULL
ORDER BY DEPTH DESC

No comments: