Re: Dealock on Rollback Segment (I think)

From: Luggy <dgh_consulting_at_my-deja.com>
Date: Thu, 28 Dec 2000 17:06:08 GMT
Message-ID: <92frts$iaq$1@nnrp1.deja.com>

Hi Patrick.

We might need a bit more info on this one.

What makes you think it is a deadlock? Do any of the processes roll back? Do any of the processes complete? Do some/all appear to be hanging? If so, are you sure they are waiting on resource?

Please post formatted output from v$lock (I can post a script to do this if required - there are many out there).

Also, what are the differences between your test and production environments? Have you got less/more larger/smaller rollback segments on live?

Dave.

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 28 2000 - 11:06:08 CST