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

网络编程 Oracle 视图 DBA_HIST_BASELINE_METADATA 官方解释，作用，如何使用详细说明 10-18

本站中文解释

Oracle视图DBA_HIST_BASELINE_METADATA是用于收集基线更改环境诊断信息的系统视图。它由基线跟踪—自Oracle Database 11g引入的新特性，可以基于数据库中已有信息组成更新基线的表生成的，并在不断的更新中反映在这个视图中。具体来说，它能够提供数据库中哪些文件及其存储在UTFFormat中的更改环境的诊断信息，它的大小，以及其它一些属性的数据。

使用DBA_HIST_BASELINE_METADATA视图的方法是在SQL命令窗口中运行以下SELECT语句：

SELECT * FROM dba_hist_baseline_metadata;

这条语句，将检索出所有关于数据库中基线更改环境诊断信息的数据，比如文件名，其存储在UTFFormat中，文件大小等等。可以根据需要，添加更多的过滤条件，改变查询的结果。

官方英文解释

DBA_HIST_BASELINE_METADATA displays metadata information for the baseline.

Column	Datatype	NULL	Description
`DBID`	`NUMBER`	`NOT NULL`	Database ID
`BASELINE_ID`	`NUMBER`	`NOT NULL`	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
`END_SNAP_ID`	`NUMBER`		End snapshot ID for 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. If the value is NULL, 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

编辑：广州明生医药有限公司

标签：基线,视图,数据库中,信息,环境