DBA_HIST_BASELINE_TEMPLATE

DBA_HIST_BASELINE_TEMPLATE displays the templates used by the system for baseline generation. The system uses this information to determine which baselines should be automatically created or removed.

Column	Datatype	NULL	Description
`DBID`	`NUMBER`	`NOT NULL`	Database ID
`TEMPLATE_ID`	`NUMBER`	`NOT NULL`	Internal ID for the template
`TEMPLATE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the template
`TEMPLATE_TYPE`	`VARCHAR2(9)`	`NOT NULL`	Type of the template, as follows: `SINGLE` - one time period `REPEATING` - maintain a time period
`BASELINE_NAME_PREFIX`	`VARCHAR2(30)`	`NOT NULL`	Name to use for the baselines that are created: For a template type of `SINGLE`, the `BASELINE_NAME_PREFIX` is the name that will be used. For a template type of `REPEATING`, the `BASELINE_NAME` will be the prefix to the name.
`START_TIME`	`DATE`	`NOT NULL`	For a template type of `SINGLE`, this is the start time for future baselines For a template type of `REPEATING`, this is the effective start time that baselines should start being generated.
`END_TIME`	`DATE`	`NOT NULL`	For a template type of `SINGLE`, this is the end time for future baselines. For a template type of `REPEATING`, this is the effective end time that baselines should stop being generated.
`DAY_OF_WEEK`	`VARCHAR2(9)`		For a template type of `REPEATING`, this indicates the day of the week to create the baseline: `SUNDAY`, `MONDAY`, `TUESDAY`, `WEDNESDAY`, `THURSDAY`, `FRIDAY`, `SATURDAY`, `ALL`.
`HOUR_IN_DAY`	`NUMBER`		For a template type of `REPEATING`, a value from 0 - 23 to indicate the hour of the day to create the baseline for.
`DURATION`	`NUMBER`		For a template type of `REPEATING`, the length of time for the baseline to be created.
`EXPIRATION`	`NUMBER`		How long to keep the baseline, in number of days
`REPEAT_INTERVAL`	`VARCHAR2(128)`		String that represents the time repeating information in the format used by the `DBMS_SCHEDULER` package
`LAST_GENERATED`	`DATE`		Last time a baseline was generated for this template