性能诊断与调优之V$--V$EVENT_NAME

最新推荐文章于 2021-04-09 01:03:07 发布

dbcommando

最新推荐文章于 2021-04-09 01:03:07 发布

阅读量952

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle SQL Tuning 文章标签： oracle database events class oracle10g concurrency

本文链接：https://blog.youkuaiyun.com/dbcommando/article/details/7644683

V$EVENT_NAME视图提供数据库实例定义的所有事件信息，而非动态视图。虽然事件数量随版本增加，如Oracle 10g有800多个，但了解常见事件即可解决大部分性能问题。EVENT_ID列提供基于事件名的稳定哈希值，WAIT_CLASS_ID和WAIT_CLASS用于按类别分组事件。

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

V$EVENT_NAME view

Contrary to its naming convention, V$EVENT_NAME is not a dynamic V$ view.The information it provides does not change over time. It is a referenceview that contains all the wait events defined for your database instance.The number of wait events varies from version to version and is also dependent on theOracle options that are installed. Upon its introduction in Oracle Release7.0.12, there were less than 100 wait events. Oracle Release 7.3.4contained a little more than 100 wait events. Oracle8i Database had over200 wait events, while Oracle9i Database has about 400. There are over 800wait events in Oracle Database 10g Release 1. But don’t let these numbersoverwhelm you. You need to familiarize yourself with only a handful ofcommon wait events, and they normally cover 80 to 90 percent of yourtroubleshooting needs. You are not expected to know all of them, but youdo need to know where to find them.

这个视图虽然看似叫动态性能视图，其实它里面的记录永远不会改变，它包括实例的所有事件，随着