Asynchronous I/O
The database server performs database I/O asynchronously, meaning that I/O is queued and performed independently of the thread that requests the I/O. Performing I/O asynchronously allows the thread that makes the request to continue working while the I/O is being performed.
The database server performs all database I/O asynchronously, using
one of the following facilities:
- AIO virtual processors
- KAIO on platforms that support it
Database I/O includes I/O for SQL statements, read-ahead, page cleaning, and checkpoints.