Re: Q: rollback sizing pt 2

From: <sybrandb_at_yahoo.com>
Date: 15 Aug 2003 04:05:40 -0700
Message-ID: <a1d154f4.0308150305.2750e015@posting.google.com>

Vince Laurent <eAddict_at_yahoo.com> wrote in message news:<tmvnjvcvcdo2h6tdlpr3cohgm81lu61vub_at_4ax.com>...
> Follow-up question: Is this something controlled by the code or an
> oracle param? I suspect the former since I can't locate anything on
> the parameter...
>
> On Thu, 14 Aug 2003 21:28:11 +0200, Sybrand Bakker
> <gooiditweg_at_sybrandb.demon.nl> wrote:
>
> >On Thu, 14 Aug 2003 10:43:45 -0500, Vince Laurent <eAddict_at_yahoo.com>
> >wrote:
> >
> >Apply
> >
> >>(d) increase the size of the individual rollbacks,
> >
> >and (e) do NOT commit every n records, as they almost always *cause*
> >ora-1555
>
> --------------------------------------
> Come race with us!
> www.mgpmrc.org

It is the parameter
_I_want_to_be_smart_and_I_do_know_better = true

Sybrand Bakker
Senior Oracle DBA Received on Fri Aug 15 2003 - 06:05:40 CDT