Re: How Long to Update a table with 33 Million records

"DOKNIK" <dominiqs_at_o2.co.uk> wrote in message news:<1060945272.456304_at_ernani.logica.co.uk>...
> All,
> I am just trying to find info on how long it will take to update a table
> with 33 million records .
> This will be done on an E-15K SUN machine with massive processing
> power, running Oracle 9i on Solaris 8 or 9
>
> How long will it take to do this update statement ..any estimates
>
>
> Here are the details
>
> 1: SGA of the database is 6 Gb
> 2:Oracle Version is 9i
> 3: network data records, primary key = telephone number (the key of
> our file)
> 4: Rollback segments, as big or as small as we need!
>
>
> (we don't have the database yet!).
> However, we consider it to be something like:
>
> Table
> ID
> DN (i.e. telephone number - 13 digitis)
> Number of other columns
> Flag (Y/N)
>
> Indicies
> A number of them on DN, and the other columes (assume 6)
>
> Table size - 70 million records.
>
> SQL
>
> Update Flag=Y Where DN=??????
>
>
> --

that really isnt that much. i cant give you exact time. depensd what else is going on. depends how many bytes of each record you are updating(will take more rollback and redo space).

dont use pl/sql to do this if you can avoid it. will take twice as long that way. straight update is faster.

its not that big of a deal. run it overnight. if it takes more than 2 hours at most id be surprised as long as nothing else is running. Received on Fri Aug 15 2003 - 10:51:58 CDT