DBA_HIST_BASELINE

DBA_HIST_BASELINE displays information on baselines taken in the system. For each baseline, this view displays the complete time range and whether the baseline is the default baseline.

Column	Datatype	Description
`DBID`	`NUMBER`	Database ID
`BASELINE_ID`	`NUMBER`	Internal ID for the baseline
`BASELINE_NAME`	`VARCHAR2(64)`	User-specified name for the baseline
`BASELINE_TYPE`	`VARCHAR2(13)`	The baseline type, as follows: `STATIC` - baselines that are created manually by the user `MOVING WINDOW` - baselines that have dynamic start and end snapshot IDs `GENERATED` - baselines that are automatically generated by the system, using a template
`START_SNAP_ID`	`NUMBER`	Start snapshot ID for the baseline
`START_SNAP_TIME`	`TIMESTAMP(3)`	Time associated with the start snapshot ID
`END_SNAP_ID`	`NUMBER`	End snapshot ID for the baseline
`END_SNAP_TIME`	`TIMESTAMP(3)`	Time associated with the end snapshot ID
`MOVING_WINDOW_SIZE`	`NUMBER`	If `BASELINE_TYPE` is `MOVING WINDOW`, this field is the size of the moving window in number of days. If NULL, then the window size is the value of the AWR retention setting.
`CREATION_TIME`	`DATE`	Time the baseline was created
`EXPIRATION`	`NUMBER`	How long to keep the baseline, in number of days. A NULL value means that the baseline will be kept forever.
`TEMPLATE_NAME`	`VARCHAR2(64)`	Name of the template that created this baseline, if any.
`LAST_TIME_COMPUTED`	`DATE`	Last time that statistics were computed on the baseline.
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data