Oracle Parallel Processing

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 ...