Redo Log Buffer Latches

From: Vincent Birlouez <birlouezv_at_hotmail.com>
Date: Mon, 18 May 1998 17:59:00 +0100
Message-ID: <356068D4.1C815CC@hotmail.com>

The Oracle tuning guide says that the ratio MISSES/GETS for redo copy should be less than 1%...As you can see below, my ratio is about 100% ! In the other hand, there is only 28 gets for a whole day. I had the feeling that it's not really a problem. What do you think ?

NAME                                          GETS    MISSES Ratio <1%

IMMEDIATE_GETS IMMEDIATE_MISSES Ratio <1%

---------------------------------------- --------- --------- ---------
-------------- ---------------- ---------
redo allocation                             537571       369
.0686421              0                0         0
redo copy                                       28        28
100         395943              184 .04644963

Thanks. Received on Mon May 18 1998 - 11:59:00 CDT