|
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. ... ... |
- Re:Fwd: please help Jared Still
- Re: Fwd: please help Ruth Gramolini
- RE: Fwd: please help Glasrot, Nechama
- Re[2]:Fwd: please help dgoulet
- Re: Fwd: please help David A. Barbour
- Re: Re[2]:Fwd: please help Jared Still
- Re[2]: Fwd: please help dgoulet
- Re[2]: Re[2]:Fwd: please help dgoulet
- RE: Fwd: please help Kimberly Smith
- Re: Fwd: please help Paul Drake
- RE: Please Help Riswandi
- RE: Please Help Christopher Spence
