(Source Code) Oracle: plan of the running query

Oracle: plan of the running query


col object_name FOR a40

SELECT operation,     
 options,     
 object_name, 
 partition_id
FROM   v$sql_plan
WHERE address IN
 ( SELECT sql_address FROM v$session WHERE sid = &sid.)
ORDER BY id;