Hi lists ...
 
I got this error when I'm running procedure.
 
- ORA-01555: snapshot too old (rollback segment too small)
 
Rollback segments statistics:
 
 CLASS                  COUNT
 ------------------ ---------
 system undo header         0
 system undo block          0
 undo header                3
 undo block                 0
 

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

 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
 
 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
 

Please help. ... ...

Reply via email to