RE: UNDO poll - was undo segments vs. rbs

  • From: Thomas Day <tday6@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 19 May 2004 09:42:41 -0400

Very high activity.  OLTP being replicated to a datamart.  Also, we need
undo retention for about 3 days.  Interfaces to other systems that need
point-in-time summaries.



                                                                                
                                                       
                      "Mercadante,                                              
                                                       
                      Thomas F"                To:      
"'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>                            
                      <thomas.mercadan         cc:                              
                                                       
                      te                       Subject: RE: UNDO poll - was 
undo segments vs. rbs                                      
                      @labor.state.ny.                                          
                                                       
                      us>                                                       
                                                       
                      Sent by:                                                  
                                                       
                      oracle-l-bounce                                           
                                                       
                                                                                
                                                       
                                                                                
                                                       
                      05/19/2004 08:59                                          
                                                       
                      AM                                                        
                                                       
                      Please respond                                            
                                                       
                      to oracle-l                                               
                                                       
                                                                                
                                                       
                                                                                
                                                       




Tom,

Just curious - is this a high activity database?  OLTP, batch , warehouse?

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Thomas Day [mailto:tday6@xxxxxxx]
Sent: Wednesday, May 19, 2004 8:49 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: UNDO poll - was undo segments vs. rbs



UNDO bigger by a factor of 2.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------




----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: