HP.com home ALLBASE/SQL Performance and Monitoring Guidelines: HP 9000 Computer Systems > Chapter 8 SQLMON Screen Reference

IO Data Session Screen

» 

Technical documentation

Complete book in PDF
 

 » Table of Contents

 » Index

This screen provides data buffer pool I/O information for each session attached to the DBEnvironment.

[datases]

To invoke the IO Data Session screen, use the d s command from the IO subsystem, or use the /i d s command from other subsystems.

When you invoke this screen, its counters are set to zero.

Field Definitions

REFRESH

The screen refresh rate, in seconds.

SESSIONS

The number of DBEnvironment sessions.

SORTIODATA

An indicator of how the sessions are sorted. The sessions are sorted in descending order by the value in the column indicated by the asterisk. In the above example, sessions are sorted by their DATA DISK WR values. For more information, see the SET SORTIODATA command.

PID

The HP-UX process identification number of the DBEnvironment session.

BUFF ACCESS

The number of page requests the session has issued to the data buffer pool.

DATA DISK RD

The number of pages that are not in the data buffer pool at request time. The operating system must fetch these pages, either from the operating system buffer pool or by a physical disk read.

DATA DISK WR

The number of dirty pages from the data buffer pool that were logically written to disk.

MISS RATE

The percentage of pages that are not in the data buffer pool at request time. The percentage is calculated as follows:


   MISS RATE = (DATA DISK RD / BUFF ACCESS) * 100

Related SET Commands

The SET commands in the following table affect this screen.

Command Description Example
SET REFRESH Controls the refresh rate of the screen. SET REFRESH 5
SET SORTIODATA Sorts sessions in descending order according to the value of the specified column. SET SORTIODATA 2
SET TOP Limits the number of sessions displayed. SET TOP 10