Re: Huge INSERT and unfriendly ROLLBACK

From: Nisar Tareen <ntareen_at_attcanada.net>
Date: Wed, 11 Nov 1998 02:13:15 GMT
Message-ID: <%o622.249$04.83970@cabot.ops.attcanada.net>

Lothar

For a rollback segment issue ,

Set rollback segment command to use particular big rollback segment,

and check what is the size of rollback segment on you database,

Rule of Thumb .. Rollback segment should be 10% of bigest table size.

One more thing if your rollback segment are big enough, just shrink them before you start your job and decrease the commit from 10000 to 1000.

If possible disable primary key before update...

Nisar Tareen

Allianz Canada. Received on Tue Nov 10 1998 - 20:13:15 CST