RE: RE: Oracle Snapshot Too Old during programatic load

ok so your not running it serially. you have say 10 inserts all running at the same time right?

well that is your problem.

they are using each others 'before image'(ie the data in the rollback segment) then you commit and the before image in the rollback segment gets written to. So it dissapears.

Therefore snapshot too old. You have a few options here.

you need to analyze your process and see what is going on. IF your doing an insert select on the same table and another transaction is doing an update. Your insert select wont see the changed records. Does this matter?
>
> From: "Smith, Ron L." <rlsmith_at_kmg.com>
> Date: 2003/07/28 Mon PM 02:49:23 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: RE: Oracle Snapshot Too Old during programatic load
>
> Yep, all at once. All inserts I believe.
>
> -----Original Message-----
> Sent: Monday, July 28, 2003 12:44 PM
> To: Multiple recipients of list ORACLE-L
>
>
> well does the load process happen serially or are you breaking it into
> pieces and doing it at once?
>
> by load I take it to mean
>
> insert
> update
> delete
> create index.
>
> correct?
> >
> > From: "Smith, Ron L." <rlsmith_at_kmg.com>
> > Date: 2003/07/28 Mon PM 01:24:23 EDT
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Subject: RE: Oracle Snapshot Too Old during programatic load
> >
> > The index is not set up with nologging. I can build the index after
> > the load with no problem. There is no other activity in the database
> > during the load process.
> >
> > Thanks!
> > Ron
> >
> > -----Original Message-----
> > Sent: Monday, July 28, 2003 11:34 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > HUH??
> >
> > Ron,
> > Is your index set up as NOLOGGING? Could you perform the load and
> > then add the index without having the error? Is there any other
> > activity on the server at the time the load is being performed? Ron
> >
> >
> > >>> oramagic_at_hotmail.com 07/28/03 12:24PM >>>
> > Try to give this index initial sufficient space so that it does not
> > autoextend the extents.
> >
> > -ak
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Monday, July 28, 2003 9:09 AM
> >
> >
> > > I asked this last week, but I have a little more info this week.
> > >
> > > I have a table that gets programmatically loaded each night. The
> > table
> > > needs to have an index added for reporting purposes. However, when
> > I
> > > add the index to the table in the TEST database I start getting
> > Snapshot
> > > Too Old errors. I added 25% more space to the RBS tablespace but it
> > > didn't do any good. I also tried reducing the frequency of commits
> > as
> > > suggested in Oracle papers but I still get the same error. If I
> > remove
> > > the index, the load works fine.
> > >
> > > Any ideas?
> > >
> > > Thanks!
> > > Ron Smith
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Smith, Ron L.
> > > INET: rlsmith_at_kmg.com
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting
> > services
> > >
> > ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L (or the
> > > name of mailing list you want to be removed from). You may also
> send
> > > the HELP command for other information (like subscribing).
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: AK
> > INET: oramagic_at_hotmail.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the
> > name of mailing list you want to be removed from). You may also send
> > the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Ron Rogers
> > INET: RROGERS_at_galottery.org
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the
> > name of mailing list you want to be removed from). You may also send
> > the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Smith, Ron L.
> > INET: rlsmith_at_kmg.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the
> > name of mailing list you want to be removed from). You may also send
> > the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <rgaffuri_at_cox.net
> INET: rgaffuri_at_cox.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from). You may also send the HELP
> command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).