Re: Where does Oracle store it's locks ?

From: Jonathan Lewis <ora_mail_at_jlcomp.demon.co.uk>
Date: 1996/11/24
Message-ID: <3298A554.54E0_at_jlcomp.demon.co.uk>#1/1

Michael Agbaglo wrote:
>
> How can I determine which rows are locked ?
> Don't want to do a lock attempt on each row. Is there a system table where
> I can retrieve these data from ?

Row locks are stored as flags on the rows themselves, so the only way to find locked rows is the one you have identified. Received on Sun Nov 24 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Michael Agbaglo: "Re: Where does Oracle store it's locks ?"
Previous message: Kelvin: "Re: Linking pro*c under Alpha VMS"
In reply to: Michael Agbaglo: "Where does Oracle store it's locks ?"
In reply to N Prabhakar: "Re: Where does Oracle store it's locks ?"
Next in thread: Michael Agbaglo: "Re: Where does Oracle store it's locks ?"
Reply: Michael Agbaglo: "Re: Where does Oracle store it's locks ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message