Re: Methods for Bulk updation

From: Saar <sxmaxoz_at_us.oracle.com>
Date: Wed, 04 Nov 1998 11:12:02 -0800
Message-ID: <3640A702.2DEF3331@us.oracle.com>

ajayanand_at_my-dejanews.com wrote:
>
> hi!
>
> Could anyone recommend some ideas for bulk updation for better performance. I
> am updating 9 millon rows, changing a number(15,6) to number(15,4).
>
> I am trying :
>
> 1. Using a big rollback.
> 2. Locking table exclusively
> 3. No archive
> 4. Update
>
> Any suggestions.

If you are really talking about UPDATE as opposed to ALTER TABLE (column..) and you are using Oracle8 you can use parallel degree on the update (PDML).

--

 __  _    _  __    _ _   _   _ ___  ______________________________ 
((  /\\  /\\ ||)  |\V/| /\\ /\\ >/  Principal Performance Engineer

_))//-\\//-\\||\ |||||//-\\\\//<_ Oracle Corporation Compaq SBU

////////////////// Drop x's in email (spam) //////////////////////

Received on Wed Nov 04 1998 - 13:12:02 CST