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;

Downloads | Post Your Resume | Jobs Alerts