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

最新推荐文章于 2025-08-31 09:44:03 发布

原创

最新推荐文章于 2025-08-31 09:44:03 发布 · 972 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #database #events #class #oracle10g #concurrency

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

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.

这个视图虽然看似叫动态性能