Tracking CPU and Other Statistics
We briefly mentioned in Chapter 2 that OWI does not capture any CPU statistics. Fortunately, this, along with myriad other statistics is exposed via the V$SYSSTAT view at the system level and the V$SESSTAT view at the session level. The V$STATNAME view provides a list of statistics that can be used to resolve the statistic name for V$SESSTAT. In short, V$SYSSTAT shows cumulative instance-wide statistics since the instance started, while V$SESSTAT shows cumulative session-wide statistics since the session started. The number and names of these statistics vary from version to version, just as with the wait events. However, the structure and meaning has mostly remained the same through the versions.
The meaning ...
Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
