« Oracle: using DBMS_METADATA for getting table structure | Home | AppleScript: rotate mov file in QuickTime Pro »
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;
Topics: Oracle, performance | Submitter: checkthis
Comments
You must be logged in to post a comment.