oracle服务器 查看存储延迟的trace日志 lgwr

[oracle@server01 trace]$ ls -lrt *lg*
-rw-r----- 1 oracle asmadmin  55823 Aug  9 14:31 sypmjt1_lgwr_8722.trm
-rw-r----- 1 oracle asmadmin 390264 Aug  9 14:31 sypmjt1_lgwr_8722.trc


当存储延迟大于500ms，会记录在lgwr trace日志中

*** 2016-08-09 00:36:17.404
Log file sync switching to post/wait
Current approximate redo synch write rate is 1 per sec
NSS2 is not running anymore.
kcrfw_update_adaptive_sync_mode: post->poll long#=6 sync#=25 sync=757 poll=1388 rw=694 ack=31 min_sleep=1057


*** 2016-08-09 07:20:39.621
Log file sync switching to polling
Current scheduling delay is 1 usec
Current approximate redo synch write rate is 8 per sec


*** 2016-08-09 07:23:44.070
NSS2 is not running anymore.
NSS2 is not running anymore.
NSS2 is not running anymore.


*** 2016-08-09 09:24:17.032
Warning: log write elapsed time 631ms, size 9KB


*** 2016-08-09 09:24:18.258
Warning: log write elapsed time 931ms, size 62KB


*** 2016-08-09 09:24:18.844
Warning: log write elapsed time 585ms, size 39KB


*** 2016-08-09 09:24:19.528
Warning: log write elapsed time 683ms, size 14KB


*** 2016-08-09 09:24:24.391
Warning: log write elapsed time 784ms, size 354KB


*** 2016-08-09 09:24:27.255
Warning: log write elapsed time 553ms, size 254KB


*** 2016-08-09 09:24:28.509
Warning: log write elapsed time 526ms, size 61KB




*** 2016-08-09 14:09:06.389
Warning: log write elapsed time 527ms, size 1342KB


*** 2016-08-09 14:09:06.928
Warning: log write elapsed time 538ms, size 456KB


*** 2016-08-09 14:09:40.175
Warning: log write elapsed time 902ms, size 2249KB


*** 2016-08-09 14:10:14.012
Warning: log write elapsed time 547ms, size 738KB


*** 2016-08-09 14:10:16.923
Warning: log write elapsed time 533ms, size 822KB


*** 2016-08-09 14:10:19.107
Warning: log write elapsed time 514ms, size 403KB


*** 2016-08-09 14:10:22.902
Warning: log write elapsed time 526ms, size 1625KB


*** 2016-08-09 14:10:42.104
Warning: log write elapsed time 524ms, size 752KB