Determinine the blocking session user - TechRepublic
General discussion
March 29, 2001 at 02:53 AM
seefet

Determinine the blocking session user

by seefet . Updated 25 years, 2 months ago

Using Oracle 8i, a table row is locked by a ‘FOR UPDATE’ clause based on a unique rowid. How can the user id of the session that has the row locked be determined? There can be other sessions waiting to update the same row.

This discussion is locked

All Comments