Search Oracle Related Sites

Thursday, July 7, 2011

11g Top 5 Timed Foregorund Events

From 11g, Oracle replaced “Top 5 Timed Events” as “Top 5 Timed Foreground Events”

Prior to Oracle 11g, wait event statistics included both foreground processes (for example, session based) and background processes (such as DBWR, SMON). It makes sense to break those different process types down into different sets of wait event statistics. He is now making clear in AWR with Foreground and Background events which will help us to focus more on foreground events.

Find below images of new names in 11g.



We will discuss more enhancements like Wait Event Histogram in next post.

No comments: