sys_ra_act_queues
The sys_ra_act_queues contains information about read-ahead queues with pending requests.
The same information is shown by the onstat -g rah queues command. The number of rows in this table is normally quite volatile since requests do not tend to remain queued for very long.
Table 1. sys_ra_act_queues table information
| Column | Type | Description |
|---|---|---|
| ra_req | int8 | Address of read-ahead request structure |
| type | char(10) | Operation type (see below) |
| req_id | integer | A number uniquely identifying the request |
| state | char(10) | Request state (see below) |
| owner | int8 | rstcb address of requestor |
| partnum | integer | Partition number being read |
| abort | smallint | Set to 1 if request is being terminated |
All possible request types:
- DATA
- LEAF
- IDX/DAT
- PAGELIST
- ROLLBACK
- LASTCOMMIT
All possible request states:
- FREE
- PENDING
- ACTIVE
- DONE
- RESCHED