The log buffer hit ratio is tracked in the view x$logbuf_readhist. A low hit ratio indicates that the LNS is frequently reading from the ORL instead of the log buffer. If there are periods when redo transport is coming close, but is not quite keeping pace with your redo generation rate, consider increasing the log buffer size in Data Guard 11g to achieve a favorable hit ratio.
Increase the log buffers
improves the read speed of the LNS process.
DESC x$logbuf_readhist Name Null Type ------------------- ------ ------------ ADDR RAW(8) INDX NUMBER INST_ID NUMBER BUFSIZE VARCHAR2(20) RDMEMBLKS VARCHAR2(24) RDDISKBLKS VARCHAR2(24) HITRATE NUMBER BUFINFO VARCHAR2(20)
select bufsize, rdmemblks, rddiskblks, hitrate from x$logbuf_readhist; BUFSIZE RDMEMBLKS RDDISKBLKS HITRATE ------- --------- ---------- ------- 2665K 484903388 42044064 92 3197K 506308671 20638781 96 3730K 508354202 18593250 96 4263K 512373070 14574382 97 9059K 523792275 3155177 99 9592K 523808659 3138793 99 10125K 523818899 3128553 99 10658K 523822995 3124457 99
No comments:
Post a Comment