Oracle教程 2023-02-24

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

本站中文解释

_RECONFIG

Oracle视图DBA_HIST_PDB_INSTANCE_RECONFIG记录着在多实例配置中重新配置Pluggable Database (PDB)实例的历史记录。它具有如下列：

使用该视图，用户可以查看在多实例配置中之前对PDB实例重新配置的历史记录。例如，通过查看STARTUP_TYPE列的值，用户可以获取PDB实例上一次启动类型，并可以通过查看RECONFIGURATION_REASON列的值查看实例被重新配置的原因。此外，用户还可以根据STARTUP_TIME和RECONFIGURATION_TIME列的值，获取PDB实例上一次启动或重新配置的时间。

可以通过以下SQL语句查看DBA_HIST_PDB_INSTANCE_RECONFIG视图的数据：

SELECT * FROM DBA_HIST_PDB_INSTANCE_RECONFIG;

官方英文解释

DBA_HIST_PDB_INSTANCE displays the pluggable databases (PDBs) and instances in the Workload Repository.

Column	Datatype	NULL	Description
`DBID`	`NUMBER`	`NOT NULL`	Database ID
`INSTANCE_NUMBER`	`NUMBER`	`NOT NULL`	Instance number
`STARTUP_TIME`	`TIMESTAMP(3)`	`NOT NULL`	Startup time of the instance
`CON_DBID`	`NUMBER`	`NOT NULL`	The database ID of the PDB for the sampled session
`OPEN_TIME`	`TIMESTAMP(3)`	`NOT NULL`	Time the PDB was last opened
`OPEN_MODE`	`VARCHAR2(16)`		Open mode of the database
`PDB_NAME`	`VARCHAR2(128)`		PDB name
`CON_ID`	`NUMBER`		The ID of the container that `CON_DBID` identifies. 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
`SNAP_ID`	`NUMBER`		The unique snapshot identifier of the snapshot that flushed the corresponding row
`STARTUP_TIME_TZ`	`TIMESTAMP(3) WITH TIME ZONE`		Startup time of the instance
`OPEN_TIME_TZ`	`TIMESTAMP(3) WITH TIME ZONE`		Time the PDB was last opened

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

分享到：

本站中文解释

官方英文解释

相关推荐