Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rollback segment too small
Ong Chin Hui wrote:
>
> On Sat, 13 Jun 1998 05:40:38 GMT, "rok" <rok_at_MCI2000.com> wrote:
>
> Thanks for responding
>
> 1. Forget to mention one thing. I perform a commit after every
> update/insert in the select.
I think that explains it. I read somewhere that you may erronously receive a snapshot_too_old-message when your job is doing many small updates and commits. You have big rollbacksegments, try committing as few times as possible. Start to test commit after every 1000. If that goes well then try 10000. If that returns ORA-1555 then it's a genuine one, go back to commit after every 1000.
Njål
--
Njål Arild Ekern, ADB-seksjonen USIT
Postboks 1059 Blindern, 0316 OSLO
Tlf 22852477, fax 22852730
Received on Tue Jun 30 1998 - 02:05:23 CDT