Re: Log switches

From: Thomas Day <tday6_at_csc.com>
Date: Wed, 7 Jul 2004 10:25:25 -0400
Message-ID: <OF75797EA5.80DE220D-ON85256ECA.004F205C@csc.com>

Will you need to reduce the size of your log_buffer? Or will forcing log switches also force the buffer to be written?

                                                                                                                                       
                      Raj Jamadagni                                                                                                    
                      <rjamya                  To:      oracle-l_at_freelists.org                                                         
                      @yahoo.com>              cc:                                                                                     
                      Sent by:                 Subject: Log switches                                                                   
                      oracle-l-bounce                                                                                                  
                                                                                                                                       
                                                                                                                                       
                      07/07/2004 10:01                                                                                                 
                      AM                                                                                                               
                      Please respond                                                                                                   
                      to oracle-l

We are testing a streams based replication ... currently log switches happen every minute, we
would like to bring this down to few seconds (to have more instantaneous data available). Is it
possible? This is 9204 environment.

TIA
Raj

Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Wed Jul 07 2004 - 10:04:24 CDT