Re: PL/SQL performance question

From: Crus <alvin_hwl_at_yahoo.com>
Date: Thu, 13 May 2004 08:57:39 +0800
Message-ID: <40a2c773$1_3@rain.i-cable.com>

If you are going to do the tweaking in a one shot, you might need to think about the size of the rollback segment. You might need to do it in batch or you will face the problem rolling back the whole and long transaction when something happen during the execution of the procedure.

Regards,

Alvin

"Marcel Stör" <marcel at frightanic dot com> wrote in message news:40a29cb5$0$139$fb624d75_at_newsspool.solnet.ch...
> Hi all,
>
> Just out of curiosity, I'd like to get your opinion on the following
> scenario:
> Lots of data (i.e. 2 million records) are periodically loaded into the db
> through SQL Loader. Unfortunately, each record needs to be tweaked before
> will eventually be saved. Would it be faster to have an on-insert trigger
do
> this at record level or to have a procedure that will run once all records
> are stored in the table?
>
> Regards,
> Marcel
>
Received on Wed May 12 2004 - 19:57:39 CDT