Oracle教程 2023-04-06

Oracle 视图 DBA_HIST_BASELINE_DETAILS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图DBA_HIST_BASELINE_DETAILS主要用于展示有关当前数据库基准线的信息，可用于确定活动基准线和已删除基准线的基本信息，例如基准线名称，基准线失效日期以及它是否为活动基准线。

使用方法：

第一步：查询所有基准线：
SELECT * FROM DBA_HIST_BASELINE_DETAILS;

第二步：查询特定基准线：
SELECT * FROM DBA_HIST_BASELINE_DETAILS WHERE BASELINE_NAME = ‘&BASELINE_NAME’;

第三步：检查特定参数的值：
SELECT value as parameter_value
FROM DBA_HIST_BASELINE_DETAILS
WHERE BASELINE_NAME = ‘&BASELINE_NAME’
AND PARAMETER_NAME = ‘&PARAMETER_NAME’;

官方英文解释

DBA_HIST_BASELINE_DETAILS displays details about the baseline.

Column	Datatype	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: `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)`	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.
`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

数据运维技术 » Oracle 视图 DBA_HIST_BASELINE_DETAILS 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐