Thanx for the reply. Version is 8.0.6.1.0 on WindowsNT 

What is the parameter that defines the no. of 'redo copy latches'. Is it
decided by Oracle or DBA has the control over it?

Regards
Naveen

-----Original Message-----
Sent: Wednesday, October 23, 2002 4:34 AM
To: Multiple recipients of list ORACLE-L


Naveen:
   What Oracle version are you using?
   The LGWR behavior has changed in version 8i.

   As far as I know (and you can read many papers about it in ixora site),
the redo copy latches are requested as immediate (no-wait mode),  all of
them except the last one. The last one is requested in wait mode.
   As you have many redo copy latches Oracle does not waste any time
sleeping for one of them, he tries the other ones first and sleep for the
last one. 
   BUT this is the LGWR behavior up to version 7.3.4, I think that in newer
versions (8i ....9i) it has changed a lot, and I believe that Oracle does
not wait for the redo copy latches any longer.
   
   I hope some Guru could confirm this and explain the new behavior in
detail.

HTH
Greetings
Diego Cutrone
   





Hi All,

When looking at v$latch it gave me the following stats for 'redo copy'

GETS: 35      
MISSES: 21
IMMEDIATE_GETS: 326975
IMMEDIATE_MISSES: 65

according to my understanding 'redo copy' is required when the process
writes
to the redo buffer. am i right?

if i'm right, why is it that this latch is requested with a no-wait
option(evident from high IMMEDIATE_GETS as compared to GETS). 

regards
Naveen
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Naveen Nahata
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dcutrone
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to