onstat -g rah command: Section 2 Active Read Ahead Queues

This section displays volatile information about currently queued read ahead requests.

Figure 2. onstat -g rah command output, section 2
Active Read Ahead Queues

ra_req     Type    ID State   Owner      Partnum   Abort
0x55318d40 DATA    33 PENDING 0x44d4f4c0 1000be    0 
0x548cdd40 LEAF    34 PENDING 0x44d4fdb8 100076    0 
0x548d8d40 IDX/DAT 35 PENDING 0x44d4f0a8 100004    0

Output description

ra_req
The memory address of the read-ahead memory structure.
Type

The operation type of the request. Possible values:

  • DATA
  • LEAF
  • IDX/DAT
  • PAGELIST
  • ROLLBACK
  • LASTCOMMIT
ID
A number uniquely identifying a particular request.
State
Requests in the queue will typically have a state of PENDING. Other possible request states:
  • FREE
  • ACTIVE
  • DONE
  • RESCHED
Owner
The rstcb address of the thread that requested the reads.
Partnum
The partition number of the table or index being read.
Abort
Indicates whether the request will be aborted, which does not necessarily indicate a malfunction. Requests may be aborted because the reader discovers it no longer needs them.