Session hanging on Scattered Read - AIX Async I/O

Hi,

Has anyone come across database sessions hanging forever on wait event - DB_FILE_SCATTERED_READ
on AIX 64bit. It would appear that it may be something to do with AIX Aysnc I/O - but not sure.

This seems to happen frequently on utility servers we are running with many oracle instances using
a wide variety of oracle versions from 7.3.4 - 9.2 . Work Load manager is in use to partition resources.

I know this is a pretty general question - but if anyone has encountered similar scenarios I would
be grateful for any feedback.

Thanks
Martin Received on Sat Mar 29 2003 - 03:35:23 CST