Oracle教程 2023-04-08

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

本站中文解释

Oracle 视图 V$LGWRIO_OUTLIER 用于监控在数据库中执行操作时，用户等待比其他会话长的操作。

用法：

1、可以检查造成用户等待的操作：

查询v$lgwrio_outlier视图

SELECT *
FROM v$lgwrio_outlier;

2、可以查看哪些临时表空间（TEMP）和undo表空间是最繁忙的：

SELECT *
FROM v$lgwrio_outlier
WHERE wait_class IN (‘undo’,’temporary’);

3、可以查看特定会话的等待概况：

SELECT *
FROM v$lgwrio_outlier
WHERE session_id = ;

官方英文解释

V$LGWRIO_OUTLIER contains entries corresponding to Log Writer (LGWR) process I/Os that have taken a long time (more than 500 ms) to complete. Use this view to see if there any occasional delays in serving disk I/O requests by the storage subsystem.

Column	Datatype	Description
`FUNCTION_NAME`	`VARCHAR2(18)`	I/O function name of the delayed I/O
`IO_SIZE`	`NUMBER`	Size of the I/O in bytes
`WAIT_EVENT`	`VARCHAR2(64)`	Wait event name that was used to track the I/O
`FILE_NAME`	`VARCHAR2(513)`	Name of the file to which the I/O was targeted
`IO_LATENCY`	`NUMBER`	Time taken to complete the I/O (in milliseconds)
`DISK1_NAME`	`VARCHAR2(255)`	For Oracle ASM, the name of the first disk to which the I/O was issued
`DISK1_LATENCY`	`NUMBER`	Latency seen on the first disk (in milliseconds)
`DISK2_NAME`	`VARCHAR2(255)`	For Oracle ASM, the name of the second disk to which the I/O was issued
`DISK2_LATENCY`	`NUMBER`	Latency seen on the second disk (in milliseconds)
`DISK3_NAME`	`VARCHAR2(255)`	For Oracle ASM, the name of the third disk to which the I/O was issued
`DISK3_LATENCY`	`NUMBER`	Latency seen on the third disk (in milliseconds)
`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

本站中文解释

官方英文解释

相关推荐