RE: Committing after every 100 deletes/updates

Here is a good article on this subject
http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci895414,00.htm l

bob

> > I did exactly as you suggested. Since the system
> > being developed is in
> > development and test phase, I am using commit
> > frequency as a environment
> > variable in the shell script that calls procedures
> > in the package. If later
> > we find problems like you mentioned snapshot too old
> > (I have come across
> > such messages earlier), I will change the value and
> > retest.
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: bmetelsky_at_cps92.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).