sys_ra_act_daemons
The sys_ra_act_daemons table contains information about read-ahead daemons currently processing requests.
The same information is shown by the onstat -g rah daemons command. The data in this table is normally quite volatile since requests do not usually take very long for a RA daemon to process.
Table 1. sys_ra_act_daemons table information
| Column | Type | Description |
|---|---|---|
| rstcb | int8 | rstcb address of read-ahead daemon |
| ra_req | int8 | Address of read-ahead request structure |
| req_id | integer | A number uniquely identifying the request |
| type | char(10) | Operation type (see below) |
| state | char(10) | Request state (see below) |
| partnum | integer | Partition number being read |
| pgs_read | integer | Total pages processed by the requestor |
| threshold | integer | Threshold at which read-aheads will continue |
| pgs_ahead | integer | Total pages read ahead by the request |
All possible request types:
- DATA
- LEAF
- IDX/DAT
- PAGELIST
- ROLLBACK
- LASTCOMMIT
All possible request states:
- FREE
- PENDING
- ACTIVE
- DONE
- RESCHED