« 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.