V$SQL_PLAN

This view contains information on execution plans for each child cursor loaded in the library cache.

Fields

The most relevant view fields are as follows:

• OPERATION: The name of the internal operation performed in the step

• OBJECT_OWNER: The owner of the object (table or index)

• OBJECT_NAME: The name of the object (table or index)

• HASH_VALUE: The hash value of the parent statement in the library cache

• SQL_ID: The SQL identifier of the parent cursor in the library cache

• PLAN_HASH_VALUE: The hash value representing the SQL plan for the cursor, useful to compare two plans

See also

The V$SQL and V$SQLAREA sections in this appendix