Re: Dealock on Rollback Segment (I think)

buckeye714_at_my-deja.com wrote:
>
> 'production' box. Using OEM, it appears that the deadlock is on a
> rollback segment. Since the application is updating rows based on
> specific rowid's, I don't believe the deadlock is a result of two
> process

Try
SET TRANSACTION USE ROLLBACK SEGMENT segment_name with different rollback segments for every update process.

-- 
____________________________________________________________
Jaros³aw Palka <jarek_at_kamsoft.com.pl> P.I.KAMSOFT, Katowice
tel. (+48 32) 209-07-05, fax 209-07-15    POLAND