O'Reilly logo

Oracle Parallel Processing by Sanjay Mishra, Tushar Mahapatra

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Monitoring Overall Statistics

There are several dynamic performance views in Oracle that contain server statistics such as events, wait times, and so forth. While these views are not used exclusively for OPS, they do contain many OPS-related statistics. Table 10.4 summarizes these views.

Table 10-4. Views with OPS-Related Statistics

Dynamic View

Description

V$SYSSTAT

GV$SYSSTAT

Provide several statistics on OPS related to database resource contention and global lock operations

V$SYSTEM_EVENT

GV$SYSTEM_EVENT

Provide wait statistics for various system events, including events related to global lock operations

V$WAITSTAT

GV$WAITSTAT

Provide statistics for the number of waits for each class of blocks

V$FILESTAT

GV$FILESTAT

Provide statistics on file reads and writes

The V$SYSSTAT View

This view contains several performance statistics. Statistics are grouped into various statistics classes. For example, statistics related to the operating system are stored with a class value of 16. Statistics specific to Oracle Parallel Server are stored with class values of 32 and 40. This section discusses some of the statistics available in this view that are related to OPS and explains how they can be used.

The following example shows V$SYSTAT being queried for all the OPS-related statistics:

SQL> SELECT * 
  2  FROM v$sysstat 
  3  WHERE class IN (32,40) 
  4  ORDER BY name; STATISTIC# NAME CLASS VALUE ---------- ---------------------------------------- ---------- ---------- 77 DBWR cross instance writes ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required