3 Replies Latest reply: Dec 8, 2010 9:16 AM by Srini Chavali-Oracle RSS

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

    821905
      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