tuning redo logs

From: Christ Follower <christ_follower_at_my-deja.com>
Date: Fri, 21 Jan 2000 20:35:20 GMT
Message-ID: <86afu7$j0l$1@nnrp1.deja.com>

I inspected V$LATCH, and the GETS and MISSES are as follows.

redo allocation 1051950      73
redo copy           221     197
redo writing     429761      20

We are running Oracle and a SUN Solaris with 4 CPUs. I am trying to increase the hit ratio for redo copy. I followed Oracle manual and increased LOG_SIMULTANEOUS_COPIES from 4 to 8 but it did not help. (Actually it seemed worse.) What else can I try?

Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jan 21 2000 - 14:35:20 CST