DBA_SQL_PLAN_BASELINES

Displays information about the SQL Plan baselines created for a specific SQL statement.

Fields

The most relevant view fields are as follows:

• SQL_HANDLE: A unique identifier

• SQL_TEXT: The un-normalized SQL text

• PLAN_NAME: A unique plan identifier

• ENABLED: This indicates whether the plan baseline is enabled (YES/NO)

• ACCEPTED: This indicates if the plan baseline is accepted (YES/NO)

• FIXED: This indicates if the plan baseline is fixed (YES/NO)

• EXECUTIONS: The number of executions at the time the plan baseline was created