Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> latch contention

latch contention

From: Keith HO Ling Soon <ling.soon.ho_at_sap-ag.de>
Date: 1997/10/08
Message-ID: <343B5DDC.2E1BAC53@sap-ag.de>#1/1 







Hi,



I have some query regarding latch contention.



    
  
  1.   How is it possible to know the size of each of  the 53 latches in
the Oracle Server?

  
  2.   How to reduce the latch contention for the rest of the latches other
than the redo allocation and redo copy latches? I only know one method :
by adjusting the parameter LOG_SIMULTANEOUS_COPIES and
LOG_SMALL_ENTRY_MAX_SIZE, contention on the redo log buffer latches can
be reduced.






Thank you in advance.




Best regards


Keith
Received on Wed Oct 08 1997 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US