Using asynchronous I/O
In this recipe we will see how to use asynchronous I/O to obtain better performance from our I/O subsystem.
How to do it...
The following steps will describe the use of asynchronous I/O:
- Connect to the database as
SYSDBA:CONNECT / AS SYSDBA - Verify whether asynchronous I/O is enabled:
SHOW PARAMETER FILESYSTEMIO_OPTIONS - Enable asynchronous I/O, if it is not enabled:
ALTER SYSTEM SET FILESYSTEMIO_OPTIONS=SETALL SCOPE=SPFILE; - Shut down the database instance:
SHUTDOWN IMMEDIATE - Start and open the database:
STARTUP OPEN - Verify the change in system configuration:
SHOW PARAMETER FILESYSTEMIO_OPTIONS
How it works...
The Oracle database may use synchronous or asynchronous I/O calls. With synchronous I/O, when an I/O request is submitted ...
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
