Re: Locks on rollback segments only

From: Steve Adams <steveadams_at_acslink.net.au>
Date: 1998/01/19
Message-ID: <34c3d7e8.74361024@newsserver.trl.oz.au>#1/1

Hello Timo,

Distributed queries/transactions exhibit this behaviour on nodes from which they read but do not modify data. The local transaction lock is necessary to map the activity to a global transaction.

Hope this helps,
Steve Adams
steveadams_at_acslink.net.au

---

On Mon, 19 Jan 1998 15:00:18 +0200, Timo Haatainen <Timo.Haatainen_at_tietogroup.com> wrote:

>Hello,
>we are experiencing a strange behaviour on Oracle 7.3.3 where some
>sessions have locks on rollback segments only, no row locks on tables.
>
>I have thought that if there is a lock on rollback segment owned by SID
>it means that this SID is writing to database and there should be locks
>on tables (or rows in table) owned by the very same SID.
>
>Here is information of a sample lock extracted from OEM's Lock Manager:
>Lock Type: TX
>Mode Held: Exclusive
>Object Name: RS1
>Object Type: ROLLBACK SEGMENT
Received on Mon Jan 19 1998 - 00:00:00 CST