ORA-01555: snapshot too old: rollback segment number 8 with name
Hi,
Database version is Oracle8i Enterprise Edition Release 8.1.7.4.0
I am struggling to fix this error, since I have not worked on 8I DATABASE.
We getting this kind of error very frequently in one of the 8i database.
ORA-01555: snapshot too old: rollback segment number 8 with name "ROLLBACK08" too small
How do i fix this permantely.
I have verified the RBS configured in the db.
SEGMENT_NAME TABLESPACE_NAME OWNER STATUS
------------------------------ ------------------------------ ------ ----------------
SYSTEM SYSTEM SYS ONLINE
ROLLBACK0 SYSTEM SYS OFFLINE
ROLLBACK02 RBS1 SYS ONLINE
ROLLBACK03 RBS1 SYS ONLINE
ROLLBACK04 RBS1 SYS ONLINE
ROLLBACK05 RBS1 SYS ONLINE
ROLLBACK06 RBS1 SYS ONLINE
ROLLBACK07 RBS1 SYS ONLINE
ROLLBACK08 RBS1 SYS ONLINE
ROLLBACK09 RBS1 SYS ONLINE
ROLLBACK10 RBS1 SYS ONLINE
ROLLBACK01 RBS1 SYS ONLINE
SQL> SELECT t1.name, t2.extents, t2.rssize, t2.optsize, t2.hwmsize, t2.xacts, t2.status FROM v$rollname t1, v$rollstat t2 WHERE t2.usn = t1.usn ;
NAME EXTENTS RSSIZE OPTSIZE HWMSIZE XACTS STATUS
------------------------------ ---------- ---------- ---------- ---------- ---------- ---------------
SYSTEM 7 770048 770048 0 ONLINE
ROLLBACK02 2 41934848 262144000 41934848 0 ONLINE
ROLLBACK03 3 62906368 262144000 62906368 1 ONLINE
ROLLBACK04 3 62906368 262144000 62906368 0 ONLINE
ROLLBACK05 2 41934848 262144000 41934848 0 ONLINE
ROLLBACK06 3 62906368 262144000 62906368 1 ONLINE
ROLLBACK07 3 62906368 262144000 62906368 1 ONLINE
ROLLBACK08 3 62906368 300146688 62906368 0 ONLINE
ROLLBACK09 3 62906368 262144000 62906368 1 ONLINE
ROLLBACK10 3 62906368 262144000 62906368 1 ONLINE
ROLLBACK01 3 62906368 300146688 62906368 0 ONLINE
NAME0 USER0 RSSIZE Wraps Extents Shrinks OPTSIZE COMM0
---------- ----------- --------- ----- ------- ------- ---------- ---------------
ROLLBACK01 62906368 19 3 0 300146688 lookup
ROLLBACK02 41934848 0 2 0 262144000 lookup
ROLLBACK03 OPS$RTRADM 62906368 20 3 0 262144000 lookup 50
ROLLBACK04 62906368 34 3 0 262144000 lookup
ROLLBACK05 OPS$RTRADM 41934848 28 2 0 262144000 No Command
ROLLBACK06 OPS$RTRADM 62906368 21 3 0 262144000 lookup 50
ROLLBACK07 OPS$RTRADM 62906368 25 3 0 262144000 lookup 50
ROLLBACK08 62906368 32 3 0 300146688 lookup
ROLLBACK09 OPS$RTRADM 62906368 20 3 0 262144000 Select
ROLLBACK10 OPS$RTRADM 62906368 24 3 0 262144000 lookup 50
SYSTEM 770048 0 7 0 lookup
Can someone help ... who to set the RBS size here... i dont want this error happens here.. what i need to look or check.