Re: Session hanging on Scattered Read - AIX Async I/O

"Martin" <mjones.satisdata_at_btinternet.com> schrieb im Newsbeitrag news:b63pcr$e18$1_at_hercules.btinternet.com...
> 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
>
>

Hi Martin,

did you try the latest bos.rte.aio fix.
If you are at AIX 4.3.3 there ist a bug (fixed with bos.rte.aio.78) that might cause such a behaviour.

Andreas Received on Sun Mar 30 2003 - 23:24:05 CST