Oracle教程 2023-04-06

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

本站中文解释

Oracle视图DBA_HIST_BASELINE_TEMPLATE主要描述了诊断框架中的性能基线模板，该视图下包括BASELINE_TEMPLATE_ID，NAME，TYPE，NOTE，STATUS，COLLECT_VALUE，CREATOR，CREATE_TIME，MODIFIER，MODIFY_TIME四个字段。

BASELINE_TEMPLATE_ID：为对应记录唯一标识符，无重复值；

NAME：性能基线模板的名称；

TYPE：性能基线模板类型；

NOTE：模板的具体说明；

STATUS：当前性能基线模板的状态；

COLLECT_VALUE：定义的数据收集的值；

CREATOR：创建性能基线模板的用户；

CREATE_TIME：性能基线模板创建时间；

MODIFIER：最后对性能基线模板有修改的用户；

MODIFY_TIME：最后修改性能基线模板信息的时间戳。

使用Oracle视图DBA_HIST_BASELINE_TEMPLATE可以实现以下功能：

1. 查看已经存在的性能基线模板信息：

SELECT * FROM DBA_HIST_BASELINE_TEMPLATE;

2. 查看特定性能基线模板的信息：

SELECT * FROM DBA_HIST_BASELINE_TEMPLATE WHERE BASELINE_TEMPLATE_ID=XXXX;

3. 按时间检索性能基线模板信息：

SELECT * FROM DBA_HIST_BASELINE_TEMPLATE WHERE CREATE_TIME>=XXXX AND CREATE_TIME

官方英文解释

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(128)`	`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(128)`	`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
`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

本站中文解释

官方英文解释

相关推荐