Oracle试图--v$system_event

最新推荐文章于 2025-02-12 08:01:26 发布

qq_38626217

最新推荐文章于 2025-02-12 08:01:26 发布

阅读量512

点赞数

本文介绍Oracle数据库中V$SYSTEM_EVENT视图的内容及各字段含义，该视图提供了关于系统级事件等待的重要信息，有助于理解并优化数据库性能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

V$SYSTEM_EVENT

V$SYSTEM_EVENT显示有关事件总等待的信息。请注意，在不支持快速计时机制的平台上，TIME_WAITED和AVERAGE_WAIT列将包含零值。如果您正在其中一个平台上运行，并希望此列反映真实的等待时间，则必须将TIMED_STATISTICS参数设置为TRUE;这样做会对系统性能产生很小的负面影响。

Column	Datatype	Description
EVENT	VARCHAR2(64)	Name of the wait event
TOTAL_WAITS	NUMBER	Total number of waits for the event
TOTAL_TIMEOUTS	NUMBER	Total number of timeouts for the event
TIME_WAITED	NUMBER	Total amount of time waited for the event (in hundredths of a second)
AVERAGE_WAIT	NUMBER	Average amount of time waited for the event (in hundredths of a second)
TIME_WAITED_MICRO	NUMBER	Total amount of time waited for the event (in microseconds)
TOTAL_WAITS_FG	NUMBER	Total number of waits for the event, from foreground sessions
TOTAL_TIMEOUTS_FG	NUMBER	Total number of timeouts for the event, from foreground sessions
TIME_WAITED_FG	NUMBER	Amount of time waited for the event (in hundredths of a second), from foreground sessions
AVERAGE_WAIT_FG	NUMBER	Average amount of time waited for the event (in hundredths of a second), from foreground sessions
TIME_WAITED_MICRO_FG	NUMBER	Amount of time waited for the event (in microseconds), from foreground sessions
EVENT_ID	NUMBER	Identifier of the wait event
WAIT_CLASS_ID	NUMBER	Identifier of the class of the wait event
WAIT_CLASS#	NUMBER	Number of the class of the wait event
WAIT_CLASS	VARCHAR2(64)	Name of the class of the wait event
CON_ID	NUMBER	The ID of the container to which the data pertains. Possible values include: 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