Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: rollback segment too small

Re: rollback segment too small

From: Njål A. Ekern <n.a.ekern_at_usit.uio.no>
Date: Tue, 30 Jun 1998 09:05:23 +0200
Message-ID: <35988E33.7C4A@usit.uio.no>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US