Hi lists ...
I got this error when I'm running
procedure.
- ORA-01555: snapshot too old (rollback segment too
small)
Rollback segments statistics:
<FONT face=Arial
size=2> CLASS
COUNT ------------------ --------- system undo
header 0 system undo
block 0 undo
header
3 undo
block
0
(db block gets + consistent
gets)/100 -------------------------------------
1041116.1
<FONT face=Arial
size=2> 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
<FONT face=Arial
size=2> 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. ...
...
Received on Wed Oct 03 2001 - 05:42:49 CDT
