Oracle教程 2023-04-07

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

本站中文解释

Oracle视图DBA_HIST_LATCH_NAME是数据库可以使用的用于跟踪等待事件的等待列表的诊断视图。它提供等待事件的ID和名称等相关信息供分析。

该视图可以用于显示在一段时间内系统等待的信息，例如：

查询DB_HIST_LATCH_NAME视图，当前系统中正在等待的等待事件的ID和名称：
SELECT WAIT_ID,LATCH_ID,LATCH_NAME FROM DBA_HIST_LATCH_NAME;

查询DB_HIST_LATCH_NAME视图，查看跟踪时间范围内发生的等待事件的ID和名称：
SELECT WAIT_ID,LATCH_ID,LATCH_NAME
FROM DBA_HIST_LATCH_NAME WHERE SNAPP_TIME >= start_time AND SYS@TIME

官方英文解释

DBA_HIST_LATCH_NAME displays information about decoded latch names for the latches shown in DBA_HIST_LATCH.

This view contains a snapshot of V$LATCHNAME.

Column	Datatype	NULL	Description
`DBID`	`NUMBER`	`NOT NULL`	Database ID
`LATCH_HASH`	`NUMBER`	`NOT NULL`	Latch hash
`LATCH_NAME`	`VARCHAR2(64)`	`NOT NULL`	Latch name
`CON_DBID`	`NUMBER`		The database ID of the PDB for the sampled session
`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

本站中文解释

官方英文解释

相关推荐