Number of I/O Servers (num_ioservers)

Configuration Type
Database

Parameter Type
Configurable

Default [Range]
3 [ 1 - 255 ]

1 [ 1 - 255 ] on Satellite database server with local clients

Unit of Measure
Counter

When Allocated
When an application connects to a database

When Freed
When an application disconnects from a database

Related Parameters

I/O servers are used on behalf of the database agents to perform prefetch I/O and asynchronous I/O by utilities such as backup and restore. This parameter specifies the number of I/O servers for a database. No more than this number of I/Os for prefetching and utilities can be in progress for a database at any time. An I/O server waits while an I/O operation that it initiated is in progress. Non-prefetch I/Os are scheduled directly from the database agents and as a result are not constrained by num_ioservers.

Recommendation: In order to fully exploit all the I/O devices in the system, a good value to use is generally one or two more than the number of physical devices on which the database resides. It is better to configure additional I/O servers, since there is minimal overhead associated with each I/O server and any unused I/O servers will remain idle.