Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback segment error
increase size of rollback is not always work(it will works if you are
lucky). this is oracle intrinsic problem. Increase rollback segment just
cause it take longer time to get this message. The best way to do it is run
you query when nobody using the database or reduce the length of you
query(like break your query into multiple pieces). that is my oppion.
Ari Kaplan wrote in message ...
>The problem is that your rollback segments are too small. The ORA-1555
>really has to do with rollback segments ; "snapshot" is a misnomer.
Increase
>the NEXT size for your rollback segments.
>
>Best regards,
>
>-Ari Kaplan
>Independent Oracle DBA
>For 350 Oracle tips, visit http://homepage.interaccess.com/~akaplan
>
>===========================================================================
=
>=======
>ckchan5_at_my-deja.com wrote in message <83ck26$57t$1_at_nnrp1.deja.com>...
>>I have the following error during select data from the table process.
>>
>>ERROR:
>>ORA-01555: snapshot too old: rollback segment number 1 with name "R05"
>>too small
>>
>>I tried to fine tune the sql statement, but still getting the same
>>error message.
>>
>>Is there any way I can overcome this error without modify my existing
>>sql statement.
>>
>>Regards
>>
>>
>>Sent via Deja.com http://www.deja.com/
>>Before you buy.
>
>
Received on Fri Dec 17 1999 - 10:59:43 CST