Message-Id: <10505.106249@fatcity.com> From: "Cunningham, Gerald" Date: Mon, 22 May 2000 12:31:46 -0400 Subject: RE: To Commit or NOT to Commit This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFC40B.14DDCE80 Content-Type: text/plain; charset="iso-8859-1" Frequent commits aren't bad when your load blows up on record # 999,999 ! Everything's a trade-off... - Jerry -----Original Message----- From: kgopal [mailto:kgopal@mantraonline.com] Sent: Monday, May 22, 2000 9:16 AM To: Multiple recipients of list ORACLE-L Subject: Re: To Commit or NOT to Commit Thats OK Joe.. My initial question was whether frequent commits will improve the insert performance (while inserting a million rows...bla..bla) I always felt frequent commits are BAD for performance. Any body has any statistics.. K Gopalakrishnan At 04:24 AM 5/22/00 -0800, Joseph S. Testa wrote: >frequent commits when fetching across commits in a pl/sql block is good >for ora-1555 errors :) > >joe > > > >kgopal wrote: >> >> Hi ! >> >> Frequent Commits are always good for performance.. >> >> Any one agree .. >> >> Gopal >> >> -- >> Author: kgopal >> INET: kgopal@mantraonline.com >> >> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >> San Diego, California -- Public Internet access / Mailing Lists >> -------------------------------------------------------------------- >> To REMOVE yourself from this mailing list, send an E-Mail message >> to: ListGuru@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). > >-- >Joe Testa http://www.oracle-dba.com >Oracle 8i documentation online http://www.oracle-dba.com/oracle-docs >-- >Author: Joseph S. Testa > INET: teci@oracle-dba.com > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru@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). > -- Author: kgopal INET: kgopal@mantraonline.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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). ------_=_NextPart_001_01BFC40B.14DDCE80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: To Commit or NOT to Commit

Frequent commits aren't bad when your load blows up = on record # 999,999 !

Everything's a trade-off...


- Jerry

-----Original Message-----
From: kgopal [mailto:kgopal@mantraonline.com]
Sent: Monday, May 22, 2000 9:16 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: To Commit or NOT to Commit


Thats OK Joe..

My initial question was whether frequent commits will = improve the insert
performance (while inserting a million = rows...bla..bla)

I always felt frequent commits are BAD for = performance.

Any body has any statistics..

K Gopalakrishnan





At 04:24 AM 5/22/00 -0800, Joseph S. Testa = wrote:
>frequent commits when fetching across commits in = a pl/sql block is good
>for ora-1555 errors :)
>
>joe
>
>
>
>kgopal wrote:
>>
>> Hi !
>>
>> Frequent Commits are always good for = performance..
>>
>> Any one agree ..
>>
>> Gopal
>>
>> --
>> Author: kgopal
>>   INET: = kgopal@mantraonline.com
>>
>> Fat City Network Services    = -- (858) 538-5051  FAX: (858) 538-5051
>> San Diego, = California        -- Public Internet = access / Mailing Lists
>> = --------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, = send an E-Mail message
>> to: ListGuru@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).
>
>--
>Joe Testa  http://www.oracle-dba.com
>Oracle 8i documentation online http://www.oracle-dba.com/oracle-docs
>--
>Author: Joseph S. Testa
>  INET: teci@oracle-dba.com
>
>Fat City Network Services    -- = (858) 538-5051  FAX: (858) 538-5051
>San Diego, = California        -- Public Internet = access / Mailing Lists
>-----------------------------------------------------------= ---------
>To REMOVE yourself from this mailing list, send = an E-Mail message
>to: ListGuru@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).
>

--
Author: kgopal
  INET: kgopal@mantraonline.com

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051
San Diego, = California        -- Public Internet = access / Mailing Lists
---------------------------------------------------------------= -----
To REMOVE yourself from this mailing list, send an = E-Mail message
to: ListGuru@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 =