DBA_SQL_PLAN_BASELINES

DBA_SQL_PLAN_BASELINES displays information about the SQL plan baselines currently created for specific SQL statements.

Column	Datatype	NULL	Description
`SIGNATURE`	`NUMBER`	`NOT NULL`	Unique SQL identifier generated from normalized SQL text
`SQL_HANDLE`	`VARCHAR2(30)`	`NOT NULL`	Unique SQL identifier in string form as a search key
`SQL_TEXT`	`CLOB`	`NOT NULL`	Un-normalized SQL text
`PLAN_NAME`	`VARCHAR2(30)`	`NOT NULL`	Unique plan identifier in string form as a search key
`CREATOR`	`VARCHAR2(30)`		User who created the plan baseline
`ORIGIN`	`VARCHAR2(14)`		How the plan baseline was created: `MANUAL-LOAD` `AUTO-CAPTURE` `MANUAL-SQLTUNE` `AUTO-SQLTUNE`
`PARSING_SCHEMA_NAME`	`VARCHAR2(30)`		Name of the parsing schema
`DESCRIPTION`	`VARCHAR2(500)`		Text description provided for the plan baseline
`VERSION`	`VARCHAR2(64)`		Database version at the time of plan baseline creation
`CREATED`	`TIMESTAMP(6)`	`NOT NULL`	Timestamp when the plan baseline was created
`LAST_MODIFIED`	`TIMESTAMP(6)`		Timestamp when the plan baseline was last modified
`LAST_EXECUTED`	`TIMESTAMP(6)`		Timestamp when the plan baseline was last executed
`LAST_VERIFIED`	`TIMESTAMP(6)`		Timestamp when the plan baseline was last verified
`ENABLED`	`VARCHAR2(3)`		Indicates whether the plan baseline is enabled (`YES`) or disabled (`NO`)
`ACCEPTED`	`VARCHAR2(3)`		Indicates whether the plan baseline is accepted (`YES`) or not (`NO`)
`FIXED`	`VARCHAR2(3)`		Indicates whether the plan baseline is fixed (`YES`) or not (`NO`)
`REPRODUCED`^Foot 1	`VARCHAR2(3)`		Indicates whether the optimizer was able to reproduce the plan (`YES`) or not (`NO`). The value of this column is set to `YES` when a plan is initially added to the plan baseline.
`AUTOPURGE`	`VARCHAR2(3)`		Indicates whether the plan baseline is auto-purged (`YES`) or not (`NO`)
`OPTIMIZER_COST`	`NUMBER`		Optimizer cost at the time the plan baseline was created
`MODULE`^Foot 2	`VARCHAR2(48)`		Application module name
`ACTION`^Footref 2	`VARCHAR2(32)`		Application action
`EXECUTIONS`	`NUMBER`		Number of executions at the time the plan baseline was created
`ELAPSED_TIME`	`NUMBER`		Total elapsed time at the time the plan baseline was created
`CPU_TIME`	`NUMBER`		Total CPU time at the time the plan baseline was created
`BUFFER_GETS`	`NUMBER`		Total buffer gets at the time the plan baseline was created
`DISK_READS`	`NUMBER`		Total disk reads at the time the plan baseline was created
`DIRECT_WRITES`	`NUMBER`		Total direct writes at the time the plan baseline was created
`ROWS_PROCESSED`	`NUMBER`		Total rows processed at the time the plan baseline was created
`FETCHES`	`NUMBER`		Total number of fetches at the time the plan baseline was created
`END_OF_FETCH_COUNT`	`NUMBER`		Total number of full fetches at the time the plan baseline was created

^Footnote 1This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).

^Footnote 2The datatype of this column is VARCHAR2(64) starting with Oracle Database 11g Release 2 (11.2.0.2).