DBA_HIST_BASELINE_DETAILS
displays details about the baseline.
Column | Datatype | NULL | Description |
---|---|---|---|
DBID |
NUMBER |
Database ID | |
INSTANCE_NUMBER |
NUMBER |
Instance ID for the baseline data | |
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:
|
|
START_SNAP_ID |
NUMBER |
Start snapshot ID for the baseline | |
START_SNAP_TIME |
TIMESTAMP(3) |
Start snapshot time for the baseline | |
END_SNAP_ID |
NUMBER |
End snapshot ID for the baseline | |
END_SNAP_TIME |
TIMESTAMP(3) |
End snapshot time for the baseline | |
SHUTDOWN |
VARCHAR2(3) |
Whether or not there is a database startup or shutdown in this interval (YES , NO , or NULL ). |
|
ERROR_COUNT |
NUMBER |
Number of errors in the snapshots in the baseline snapshot range | |
PCT_TOTAL_TIME |
NUMBER |
Amount of time captured in snapshots, divided by the total possible time for this baseline | |
LAST_TIME_COMPUTED |
DATE |
Last time that statistics were computed on the baseline | |
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 value of NULL indicates that the baseline will be kept forever. | |
TEMPLATE_NAME |
VARCHAR2(64) |
Name of the template that created this baseline, if any. |