This discussion is archived
3 Replies Latest reply: Dec 8, 2010 7:16 AM by Srini Chavali-Oracle RSS

WARNING:Could not lower the asynch I/O limit to 1056 for SQL direct I/O.

821905 Newbie
Currently Being Moderated
Hi ,

I am getting below warnings in the user dump after upgrading to 10.2.0.5 from 9.2.0.1 on windows server (32 bit)

WARNING:Could not lower the asynch I/O limit to 1056 for SQL direct I/O. It is set to -1

Kindly let me know as to why these warnings are generated in the user dump.

SQL> show parameter synch

NAME TYPE VALUE
------------------------------------ ----------- ---------
disk_asynch_io boolean TRUE
tape_asynch_io boolean TRUE

Thanks,
Sachin

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points