136156188 发表于 2019-8-9 17:11:29

ADG备库应用归档日志比较慢

主备都是linux,Database Patch Set Update : 11.2.0.4.161018 (24006111)
ADG备库alert没有异常、没有报错,但是应用归档日志比较慢，对mrp0做了一个10046跟踪，发现全是db file parallel read等待事件

WAIT #0: nam='db file parallel read' ela= 51686 files=10 blocks=32 requests=32 obj#=-1 tim=1565334068118621
WAIT #0: nam='db file parallel read' ela= 97984 files=17 blocks=32 requests=32 obj#=-1 tim=1565334068216924
WAIT #0: nam='db file parallel read' ela= 58613 files=11 blocks=32 requests=32 obj#=-1 tim=1565334068275869
WAIT #0: nam='db file parallel read' ela= 78864 files=17 blocks=32 requests=32 obj#=-1 tim=1565334068355037
WAIT #0: nam='db file parallel read' ela= 112901 files=14 blocks=32 requests=32 obj#=-1 tim=1565334068468233
WAIT #0: nam='db file parallel read' ela= 5000 files=1 blocks=32 requests=32 obj#=-1 tim=1565334068473793
WAIT #0: nam='db file parallel read' ela= 43503 files=5 blocks=32 requests=32 obj#=-1 tim=1565334068517677

请问该如何继续分析和处理？

xifenfei 发表于 2019-8-9 20:00:58

你可通过iostat -x 1 10 观察下磁盘的繁忙程度

136156188 发表于 2019-8-10 14:58:06

收到，找人分析存储io性能去
页: [1]
查看完整版本: ADG备库应用归档日志比较慢