web analytics

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;