1 Reply Latest reply: Nov 30, 2012 2:57 AM by Toni Lazarin RSS

    Huge Log File Sync Waits

    Vivek Sharma-Mumbai-Oracle
      Hi All,

      I am facing a severe Log file sync waits. This is IBM AIX 6.1 and 11202. The Storage response time seems to be perfectly fine. The truss output of LGWR shows waits on aio_nwait_timeout64. Attached below is a small portion of the truss output.

                                    = 0
      0.0000: thread_post(98828793)          = 0
      0.0002: thread_post(98828793)          = 0
      0.0003: thread_post(32179239)          = 0
      0.0003: thread_post(32179239)          = 0
      0.0007: listio64(0x0000000010000004, 0x000000000FFFFFFF, 0x00000000FFFF8E60, 0x0000000000000002, 0x0000000000000000, 0x0000000000000000, 0x0000000110C09988, 0x0000000000000040) = 0x0000000000000000
      0.0005: aio_nwait_timeout64(0x0000000000001000, 0x0000000000000002, 0x0FFFFFFFFFFF2760, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000, 0x0000000110B30890, 0x0000000000000002) = 0x0000000000000000
      0.0002: aio_nwait_timeout64(0x0000000000001000, 0x0000000000000002, 0x0FFFFFFFFFFF27D0, 0xFFFFFFFFFFFFFFF6, 0x0000000000000000, 0x00000000FFFFFFFF, 0x0000000000000000, 0x0000000000000000) = 0x0000000000000002
      0.0005: _ensendmsg(12, 0x0FFFFFFFFFFFB240, 0, 0x0000000000000000) = 144

      Would appreciate any suggestions or help on this. MOS Note 1318709.1 seems to be relevant and points on the issue with async descriptors.

      Regards
      Vivek