Re: Interesting question about locks !

or you could just sing "The Lion Sleeps tonight" while spinning in your chair.

Iosif Tanasescu wrote:

> Hi
>
> try:
>
> select ORACLE_USERNAME||' is currently locking '||owner||'.'||object_name,
> ' from terminal '||os_user_name||' with the program:'||PROGRAM
> from
> v$locked_object a,
> all_objects b,
> v$session c
> where
> a.object_id = b.object_id
> and c.sid=a.session_id
> /
>
> bye!
>
> Didier LENQUETTE wrote:
>
> > Hi !
> >
> > I manage locks into my database with SELECT ... FOR UPDATE NOWAIT.
> >
> > When a record is already locked by another user, I wish to know who is
> > locking the record I am trying to lock.
> >
> > I know the locked objects with the v$lock view and the "locker", but I don't
> > know who locks a particular record !
> >
> > Example :
> > User A lock row #1 and #3 of table1
> > User B tries to lock row #3 of table1 : he becomes error -54 OK !
> > I want to know who is locking row #3 in order to display a message like
> > 'User A locks row #3'
> >
> > An idea ?
> >
> > --
> >
> > ________________
> > Didier LENQUETTE
> > Tel : (33) 5 62 12 20 40
> > Fax : (33) 5 61 31 07 02
Received on Tue Feb 29 2000 - 00:00:00 CST