The query corresponding to each monitoring element to check the information related to the service thread is as follows.
| RUN_MODE / TYPE | Mode of operation of the service thread / SHARED, DEDICATED |
|---|---|
| STATE | The state of the service thread. In general, it is in the POLL or EXECUTE state. NONE: Service thread initialized POLL: Service thread is waiting for an event QUEUE-WAIT: Service thread is waiting for a task queue EXECUTE: Service thread is executing query |
Main Column Description
| Column | Description |
|---|---|
| MISS_COUNT | The number of times a request was made to the service thread to process the statement, but failed due to busy. |
| TRY_COUNT | The number of times a service thread was requested to process a statement |
| PER | miss_count / try_count * 100 |