Re: To Commit or NOT to Commit

Hi,

  Deferring COMMITS because of availability of HUGEEEEEE rollback   segments is a very costly decision UNLESS the nature of the   application/transaction demands that. Ever for such transactions   I can imagine a count of 50 or 100 rows but not definetly "million"   rows.

  Dependending on the activity in the database, this would add   considerable overhead to the system viz maintaining consistent   Snapshots for the users where it would scan the rollback segments   also.

  BOTTOM LINE, NEVER EVER ATTEMPT THIS !!!!! Regards
Rajagopal Venkataramany

----Original Message Follows----
From: "kgopal" <kgopal_at_mantraonline.com> Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: Re: To Commit or NOT to Commit
Date: Mon, 22 May 2000 02:15:50 -0800

Ok..

I am inserting a million rows in a table..

To commit or not to commit.
I have HUGEEEEEE Rollback Segments and 16 CPUs.

At 12:26 AM 5/22/00 -0800, Andreas Jung wrote:
>On Sun, May 21, 2000 at 11:44:41PM -0800, kgopal wrote:
>> Hi !
>>
>> Frequent Commits are always good for performance..
>>
>> Any one agree ..
>
>Depends on what you're doing ....
>
>--
>Author: Andreas Jung
> INET: ajung_at_sz-sb.de
>
>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).

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com