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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to avoid rollback during some INSERTs ?

Re: How to avoid rollback during some INSERTs ?

From: <kvsraju_at_my-dejanews.com>
Date: Sun, 31 Jan 1999 05:31:06 GMT
Message-ID: <790pqq$3b4$1@nnrp1.dejanews.com>


In article <787dv9$iik$1_at_nnrp1.dejanews.com>,   frank_delisle_at_hotmail.com wrote:
> Just use a bigger rollback segment!!!
> In article <78571l$o58$1_at_smilodon.ecp.fr>,
> riad_at_innocent.ANTI-SPAM.ORG wrote:
> >
> > Hi.
> >
> > I have some inserts (insert into toto values(...) select ....) that are
pretty huge.
> > usually, they explode the rollbacks (the table is indexed by two indexes,
which
> > make the charge heavier on the rollback).
> > So what I do, I insert into this table by chunks of 10000 rows.
> >
> > But I would like to know if there is some simple way to avoiding using
rollbacks
> > during some inserts (like NOLOGGING avoid using logs) ????
> >
> > I don't care if the information would not be restorable, because if
something wrong
> > happens, I know eaxctly which rows I remove (referenced by a date).
> >
> > So any suggestions ?
> >
> > thanks in advance.
> > Riad
> > ----------------------------------------------
> > To email, replace the "ANTI-SPAM.ORG" by "com"
> > ----------------------------------------------
> >
>
> Frank Delisle
> Consultant, Eds Québec
> e-mail: francois.delisle_at_prosig.qc.ca
> "Un problème sans solution n'est pas un problème"
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

Hi,
There are transactions called DISCRETE transactions .Which don't use rollback segments.
rgds
kvsraju_at_polaris.co.in

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Jan 30 1999 - 23:31:06 CST

Original text of this message

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