Where does Oracle store it's locks ?

From: Michael Agbaglo <michael_at_isv-gmbh.de>
Date: 1996/11/21
Message-ID: <01bbd7b7$09863d00$c9bf73c2_at_PC-4-01-201.isv-gmbh.de>#1/1

I have to visualize seats that can be free, reserved or sold. Before a seat can be reserved or sold it must be locked via row level locking. The application should see the locked seats as not available (sold or reserved) therefore I need to lookup which rows are locked. checking each row which a try to lock is inefficient.

Where can I lookup the locks ? Received on Thu Nov 21 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Rene L. Rodriguez: "Quality of college education, am I being properly prepared?"
Previous message: N Prabhakar: "Re: more that one instance"
Maybe reply: Thomas J. Kyte: "Re: Where does Oracle store it's locks ?"

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

Original text of this message