Re: Documentation on Transaction Management
From: rjamya <rjamya_at_gmail.com>
Date: Thu, 19 Nov 2009 21:16:33 -0500
Message-ID: <9177895d0911191816m735fd46eucb031c4699da5da6_at_mail.gmail.com>
10m rows should not be more than a few minutes unless there are lots of active transactions and/or indexes. I'd try to minimize outside lookups and by scanning the table (to be updated) first, get values from lookup tables and cache them locally then run simple updates.
Date: Thu, 19 Nov 2009 21:16:33 -0500
Message-ID: <9177895d0911191816m735fd46eucb031c4699da5da6_at_mail.gmail.com>
10m rows should not be more than a few minutes unless there are lots of active transactions and/or indexes. I'd try to minimize outside lookups and by scanning the table (to be updated) first, get values from lookup tables and cache them locally then run simple updates.
Then again we are talking about lack of more info :)
Raj
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 19 2009 - 20:16:33 CST