log file sync + asynch descriptor resize

Liu Maclean(刘相兵

*** 2012-02-11 17:45:48.736
Warning: log write elapsed time 2569ms, size 3KB

*** 2012-02-11 17:45:53.133
Warning: log write elapsed time 1593ms, size 0KB

*** 2012-02-11 17:45:57.329
Warning: log write elapsed time 2059ms, size 4KB

*** 2012-02-11 17:45:59.095
Warning: log write elapsed time 1748ms, size 5KB

*** 2012-02-11 17:46:02.155
Warning: log write elapsed time 1600ms, size 8KB

*** 2012-02-11 17:47:43.526
Warning: log write elapsed time 92562ms, size 2KB

*** 2012-02-11 17:47:45.859
Warning: log write elapsed time 2320ms, size 15040KB

*** 2012-02-11 17:49:38.506
Warning: log write elapsed time 108507ms, size 11KB



asynch descriptor resize

Bug 12412983: PROCESS HUNGON ASYNCH DESCRIPTOR RESIZE AFTER UPGRADE TO 11.2.0.2

Bug 12412983 - AIX: "asynch descriptor resize" wait not necessary on AIX (Doc ID 12412983.8)

Hi,
Please check the list in note:
        AIX: Things To Check When Seeing Long Log File Sync Time in 11.2. (Doc ID 1318709.1)

通过以上文档中的内容
applying the fix for Bug 12412983 - AIX: "asynch descriptor resize" may also help

Performing  a TRUSS of LGWR  e.g. truss -dD -o lgwrtruss.log -p <ospid>