Updated on 2024-06-03 GMT+08:00

GLOBAL_ADIO_COMPLETER_STATUS

GLOBAL_ADIO_COMPLETER_STATUS displays statistics about the AIO Completer thread in all database instances, as described in Table 1.

Table 1 GLOBAL_ADIO_COMPLETER_STATUS columns

Name

Type

Description

node_name

text

Instance name.

tid

int8

ID of the AIO Completer thread.

thread_type

text

AIO Completer thread type (read or write).

aio_submitted_num

int8

Number of committed asynchronous I/O requests of the AIO Completer thread.

aio_completed_num

int8

Number of completed asynchronous I/O requests of the AIO Completer thread.

aio_incompleted_num

int8

Number of asynchronous I/O requests that are not completed of the AIO Completer thread.

slot_count_left

int8

Indicates the number of idle slots.