Re: Dealock on Rollback Segment (I think)

Unless I've missed something in the manuals, you can't do a parallel update unless the table is a partitioned table. The only parallel DML that can be run on a non-partitioned table is 'insert into ... select * from ...' where each inserting PX slave adds its own extent to the existing segment.

It might be worth looking at partitioning the table though to make this possible.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Brian Peasland wrote in message <3A4C9B00.8723A9E5_at_edcmail.cr.usgs.gov>...


>After carefully reading the other responses to this posting, I thought

>that I would weigh in on a slightly different take on the subject.

>

>By splitting the update process into 8 separate processes, the

>consultant just forced this update process to be run in parallel. Since

>you are using Oracle 8i, why not just use parallel DML to perform the

>same operation? In the end, you might be better served since Oracle is

>handling the parallel operations for you. This means that you won't be

>getting a deadlock situation.

>

>Just my 3.14159265 cents worth,

>Brian

>

>