Re: Any good monitor script for LOCKED object V$LOCK

"dominica_at_gmail.com" <dominica_at_gmail.com> wrote in news:1118872747.609890.52090_at_f14g2000cwb.googlegroups.com:

> Hi,
>
> Because in my work, there is a bunch of locked object going on.
>
> That is why I would like to monitor the "locked object" and to find
> out which segment.
>

Then query
desc v$locked_object

 Name                                      Null?    Type
 ----------------------------------------- -------- -----------------------
 XIDUSN                                             NUMBER
 XIDSLOT                                            NUMBER
 XIDSQN                                             NUMBER
 OBJECT_ID                                          NUMBER
 SESSION_ID                                         NUMBER
 ORACLE_USERNAME                                    VARCHAR2(30)
 OS_USER_NAME                                       VARCHAR2(30)
 PROCESS                                            VARCHAR2(12)
 LOCKED_MODE                                        NUMBER