search for: disk_asynch_io

...backup/TR1_88_1 ORA-19502: write error on file "/db/devices/db1/PR2/pr2_1/pr2.data1", blockno 1409 (blocksize=8192) ORA-27061: waiting for async I/Os failed Linux-x86_64 Error: 5: Input/output error Tried various Oracle init parameters for filesystem i/o SETALL, ASYNCH, DIRECT and also disk_asynch_io settings. After this failure tried to used a non ocfs2 filesytem (ext3) for the source RMAN backup files, however the error still occurred. For testing purposes specified a non ocfs2 filesystem ( ext3 ) as restore target filesystem and the RMAN restore completed successfully without any errors....

We have an Oracle 10.2.0.3 installation on a Sun T2000 logical domain. The virtual disk has a ZFS file system. When we try to create a tablespace we get these errors: WARNING: aiowait timed out 1 times WARNING: aiowait timed out 2 times WARNING: aiowait timed out 3 times ... Does disk_asynch_io = false need to be set with ZFS? This page: http://blogs.sun.com/glennf/entry/where_do_you_cache_oracle says "ZFS which doesn''t allow for direct or async IO." but nothing else I''ve found indicates that setting must be set. Thanks This message posted from opensolaris...

How can I tell if this is normal behaviour? Oracle imports are horribly slow, an order of magnitude slower than on the same hardware with a slower disk array and Solaris 9. What I can look for to see where the problem lies? The server is 99% idle right now, with one database running. Each sample is about 5 seconds. I''ve tried setting kernel parameters despite the docs saying that