Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Huge Log File Sync Waits

Vivek Sharma-Mumbai-OracleNov 27 2012 — edited Nov 30 2012

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 28 2012

Added on Nov 27 2012

#11gr2, #performance, #performance-availability, #real-application-clusters

1 comment

1,019 views