Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Locks on rollback segments only

Locks on rollback segments only

From: Timo Haatainen <Timo.Haatainen_at_tietogroup.com>
Date: 1998/01/19
Message-ID: <34C34E62.763B@tietogroup.com>#1/1

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

Thanks in advance

-- 

Timo Haatainen
TT-Tieto Oy
Received on Mon Jan 19 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US