| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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...
-----Original Message-----
From: kgopal [mailto:kgopal_at_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_at_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_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).
>
>--
>Joe Testa http://www.oracle-dba.com
>Oracle 8i documentation online http://www.oracle-dba.com/oracle-docs
>--
>Author: Joseph S. Testa
> INET: teci_at_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_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).
>
-- Author: kgopal INET: kgopal_at_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_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). ------_=_NextPart_001_01BFC40B.14DDCE80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: To Commit or NOT to Commit</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Frequent commits aren't bad when your load blows up = on record # 999,999 !</FONT> </P> <P><FONT SIZE=3D2>Everything's a trade-off...</FONT> </P> <BR> <P><FONT SIZE=3D2>- Jerry</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: kgopal [<A = HREF=3D"mailto:kgopal_at_mantraonline.com">mailto:kgopal_at_mantraonline.com</= A>]</FONT> <BR><FONT SIZE=3D2>Sent: Monday, May 22, 2000 9:16 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: To Commit or NOT to Commit</FONT> </P> <BR> <P><FONT SIZE=3D2>Thats OK Joe..</FONT> </P> <P><FONT SIZE=3D2>My initial question was whether frequent commits will = improve the insert </FONT> <BR><FONT SIZE=3D2>performance (while inserting a million = rows...bla..bla)</FONT> </P> <P><FONT SIZE=3D2>I always felt frequent commits are BAD for = performance.</FONT> </P> <P><FONT SIZE=3D2>Any body has any statistics..</FONT> </P> <P><FONT SIZE=3D2>K Gopalakrishnan</FONT> </P> <BR> <BR> <BR> <BR> <P><FONT SIZE=3D2>At 04:24 AM 5/22/00 -0800, Joseph S. Testa = wrote:</FONT> <BR><FONT SIZE=3D2>>frequent commits when fetching across commits in = a pl/sql block is good</FONT> <BR><FONT SIZE=3D2>>for ora-1555 errors :)</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>joe</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>kgopal wrote:</FONT> <BR><FONT SIZE=3D2>>> </FONT> <BR><FONT SIZE=3D2>>> Hi !</FONT> <BR><FONT SIZE=3D2>>> </FONT> <BR><FONT SIZE=3D2>>> Frequent Commits are always good for = performance..</FONT> <BR><FONT SIZE=3D2>>> </FONT> <BR><FONT SIZE=3D2>>> Any one agree ..</FONT> <BR><FONT SIZE=3D2>>> </FONT> <BR><FONT SIZE=3D2>>> Gopal</FONT> <BR><FONT SIZE=3D2>>> </FONT> <BR><FONT SIZE=3D2>>> --</FONT> <BR><FONT SIZE=3D2>>> Author: kgopal</FONT> <BR><FONT SIZE=3D2>>> INET: = kgopal_at_mantraonline.com</FONT> <BR><FONT SIZE=3D2>>> </FONT> <BR><FONT SIZE=3D2>>> Fat City Network Services = -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>>> San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>>> To REMOVE yourself from this mailing list, = send an E-Mail message</FONT> <BR><FONT SIZE=3D2>>> to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>>> the message BODY, include a line = containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>>> (or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>>> also send the HELP command for other = information (like subscribing).</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>-- </FONT> <BR><FONT SIZE=3D2>>Joe Testa <A = HREF=3D"http://www.oracle-dba.com" = TARGET=3D"_blank">http://www.oracle-dba.com</A></FONT> <BR><FONT SIZE=3D2>>Oracle 8i documentation online <A = HREF=3D"http://www.oracle-dba.com/oracle-docs" = TARGET=3D"_blank">http://www.oracle-dba.com/oracle-docs</A></FONT> <BR><FONT SIZE=3D2>>-- </FONT> <BR><FONT SIZE=3D2>>Author: Joseph S. Testa</FONT> <BR><FONT SIZE=3D2>> INET: teci_at_oracle-dba.com</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>>-----------------------------------------------------------= ---------</FONT> <BR><FONT SIZE=3D2>>To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>>the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>>(or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>>also send the HELP command for other information = (like subscribing).</FONT> <BR><FONT SIZE=3D2>></FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: kgopal</FONT> <BR><FONT SIZE=3D2> INET: kgopal_at_mantraonline.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Mon May 22 2000 - 11:31:46 CDT
 |
 |