Database Administration (MOSC)

MOSC Banner

ASYNCH IO Disabled however still asynch IO waits Been Seen

edited Aug 30, 2011 3:11PM in Database Administration (MOSC) 2 commentsAnswered
Hello ,
asynch appears to be disabled from the DB side (FILESYSTEMIO_OPTIONS=DIRECT, ASYNCH_DISK_IO=FALSE, ASYNCH_TAPE_IO=FALSE and mount file system mount option FORCEDIRECTIO) we still see asynch IO waits in v$session for the RMAN processes. These asynch IO waits are extremely long and resulting in the RMAN backups taking 2x longer than they did with asynch IO enabled. Why is this and what can we do to fix it?

These are UFS file systems.

DB : 9.2.0.7
OS : Oracle Solaris on SPARC (64-bit)

Please advise

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center