RE: Please Help

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Wed, 03 Oct 2001 06:09:36 -0700
Message-ID: <F001.003A049E.20011003054020@fatcity.com>

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>This is covered very well and in detail in the manuals, but in short it means you had a transaction write to a rollback segment, then a long running query requested this information for read consistency before the transaction (cause it was already started before the transactions started) and it doesn't have the rollback information available to rebuild the transaction. 
This usually happens when you have long running queries during heavy transactional periods.

<span style='font-size:

10.0pt;font-family:Arial;color:navy'> 

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>In short, increase your rollback segments size or number of extents, but don't increase them so much as that they are huge for your needs.

<span style='font-size:

10.0pt;font-family:Arial;color:navy'> 

<span style='font-size:12.0pt;

color:navy;mso-no-proof:yes'>"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

<span style='font-size:18.0pt;

font-family:"Comic Sans MS";color:navy;mso-no-proof:yes'>Christopher R. Spence<font color=navy>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Oracle DBA<span style='color:navy;
mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Phone: (978) 322-5744<span
style='color:navy;mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Fax:    (707) 885-2275<span
style='color:navy;mso-no-proof:yes'>

<span style='font-size:10.0pt;

font-family:"Comic Sans MS";color:navy;mso-no-proof:yes'>Fuelspot<font color=navy>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>73 Princeton Street<span style='color:navy; mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>North, Chelmsford 01863<span
style='color:navy;mso-no-proof:yes'>
 

<span

style='font-size:10.0pt;font-family:Tahoma'>-----Original Message----- From: Riswandi
[mailto:riswandi_at_polyfincanggih.com]
Sent: Wednesday, October 03, 2001
7:01 AM
To: Multiple recipients of list
ORACLE-L
Subject: Please Help

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial'>Hi lists ...

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial'>I got this error when I'm running procedure.

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial'>- ORA-01555: snapshot too old (rollback segment too small)

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial'>Rollback segments statistics:

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial'> CLASS                 

COUNT

 ------------------ ---------
 system undo header         0

 system undo block          0
 undo
header               
3
 undo

block                

0

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial'>

 (db block gets + consistent gets)/100
 -------------------------------------
                            

1041116.1

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial'>  SUBSTR(NAME,1,40)               
EXTENTS    RSSIZE AVEACTIVE   OPTSIZE
AVESHRINK   EXTENDS   SHRINKS

 ------------------------------ --------- --------- --------- ---------

--------- --------- ---------

 RB0                                   

3   2170880    328140  

1572864        
0        
0         0
 RB1                                   

3   2170880   1828001   1048576  

6291456        
7         1
 RB2                                   

2   1122304    202338   1048576  

1048576        
2         2
 RB3                                   

2   1122304    309818   1048576  

1048576        
1         1
 RB4                                   

2   1122304    352696   1048576  

2097152        
2         1
 RB5                                   

2   1122304    309818   1048576  
1048576         1        
1

 RB6                                   

2   1122304    309818   1048576  

1048576        
1         1
 RB7                                   

2   1122304    320911   1048576  

1048576        
1         1
 RB8                                   

2   1122304    374967   1048576  

1048576        
1         1
 RB9                                   

2   1122304    275972   1048576  

1048576        
1         1
 RB10                                  
2   1122304    254828  

1048576        
0         0        
0

 RB11                                  

3   2170880    277233  

1048576        
0        
1         0
 RB13                                  

2   1572864    275197  

1310720        
0        
0         0

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial'> SEGMENT_NAME                  

INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS

 ------------------------------ -------------- ----------- -----------

---

 RB0                                    
57344     1048576          
2         100
 RB1                                    
57344    
1048576          
2         100
 RB2                                    
57344    
1048576          
2         100
 RB3                                    

57344    
1048576           2        
100

 RB4                                    
57344    
1048576          
2         100
 RB5                                    
57344    
1048576          
2         100
 RB6                                    
57344    
1048576          
2         100
 RB7                                    
57344    
1048576          
2         100
 RB8                                    
57344    
1048576          
2         100
 RB9                                    
57344    
1048576          
2         100
 RB10                                   
57344     1048576          
2         100
 RB11                                   
57344     1048576          
2         100
 RB13                                  

524288     1048576          
2         100

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial'> Please help. ... ... Received on Wed Oct 03 2001 - 08:09:36 CDT