-1555-ORA-01555: snapshot too old: rollback segment number 7 with name "_SYSSMU7$" too small

From: <spremuta_at_gmail.com>
Date: 12 Sep 2006 02:34:31 -0700
Message-ID: <1158053671.670083.296380@p79g2000cwp.googlegroups.com>

Hi, i have this errors in an oracle 9.0.2 db, on a hp-ux system. I have read some info about this issue, i executed this query:

SELECT segment_name, tablespace_name, bytes, blocks, extents FROM sys.dba_segments where tablespace_name like 'UN%';

and i obtained this results:

SEGMENT_NAME,TABLESPACE_NAME,BYTES,BLOCKS,EXTENTS
_SYSSMU1$,UNDOTBS1,15446671360,1885580,392
_SYSSMU2$,UNDOTBS1,570548224,69647,49
_SYSSMU3$,UNDOTBS1,1812062208,221199,112
_SYSSMU4$,UNDOTBS1,814866432,99471,101
_SYSSMU5$,UNDOTBS1,620879872,75791,48
_SYSSMU6$,UNDOTBS1,520216576,63503,64
_SYSSMU7$,UNDOTBS1,335667200,40975,7
_SYSSMU8$,UNDOTBS1,478273536,58383,59
_SYSSMU9$,UNDOTBS1,679600128,82959,76
_SYSSMU10$,UNDOTBS1,1263656960,154255,105
_SYSSMU11$,UNDOTBS1,6618734592,807951,213
_SYSSMU12$,UNDOTBS1,1282531328,156559,78
_SYSSMU13$,UNDOTBS1,910286848,111119,23
_SYSSMU14$,UNDOTBS1,444719104,54287,55
_SYSSMU15$,UNDOTBS1,309452800,37775,39
_SYSSMU16$,UNDOTBS1,335667200,40975,7
_SYSSMU17$,UNDOTBS1,258072576,31503,19
_SYSSMU18$,UNDOTBS1,4806795264,586767,186
_SYSSMU19$,UNDOTBS1,1198645248,146319,141
_SYSSMU20$,UNDOTBS1,369221632,45071,11
_SYSSMU21$,UNDOTBS1,193060864,23567,25
_SYSSMU22$,UNDOTBS1,226615296,27663,22
_SYSSMU23$,UNDOTBS1,15470837760,1888530,445
_SYSSMU24$,UNDOTBS1,939646976,114703,65
_SYSSMU25$,UNDOTBS1,1090641920,133135,48
_SYSSMU26$,UNDOTBS1,67231744,8207,10
_SYSSMU27$,UNDOTBS1,1115807744,136207,19
i obtain this errors even for segment _SYSSMU6

in my $ORACLE_SID.ora file i have this options:

db_block_size = 8192
db_cache_size = 33554432
db_domain = ''
db_file_multiblock_read_count = 16

dispatchers = '(PROTOCOL=TCP) (SERVICE=ovpiXDB)' fast_start_mttr_target = 300
hash_join_enabled = TRUE
instance_name = ovpi
java_pool_size = 117440512
job_queue_processes = 10
large_pool_size = 16777216
log_archive_dest_1 = 'LOCATION=/opt/oracle/product/9.2.0/dbs/arch' open_cursors = 300
pga_aggregate_target = 25165824
processes = 150
query_rewrite_enabled = FALSE
remote_login_passwordfile = SHARED
shared_pool_size = 117440512
sort_area_size = 524288
star_transformation_enabled = FALSE
timed_statistics = TRUE

undo_management = AUTO
undo_retention = 10800
undo_tablespace = UNDOTBS1
user_dump_dest = /opt/oracle/admin/ovpi/udump

thanks for assistance
regards

Drain Received on Tue Sep 12 2006 - 04:34:31 CDT