Re: locked session

> Look at v$lock. There are 'held' (who has got the lock) and 'requested'
> (who wants it) columns. There is also a time for how long someone has
> had or has been waiting for the lock.

I wish it would be that simple!
I have Oracle 816

I believe the same information can be found, but not with those column names.
What`s the equivalent in 816?
Thanks

SQL> desc v$lock

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------------
----
 ADDR                                            RAW(8)
 KADDR                                         RAW(8)
 SID                                                NUMBER
 TYPE                                             VARCHAR2(2)
 ID1                                                NUMBER
 ID2                                                NUMBER
 LMODE                                         NUMBER
 REQUEST                                      NUMBER
 CTIME                                           NUMBER
 BLOCK                                          NUMBER

--

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove zulu from my address

"Connor McDonald" <connor_mcdonald_at_yahoo.com> a écrit dans le message de
news: 3D5C072A.2E7A_at_yahoo.com...


> OlgaS wrote:

> >

> > Hi! At us a problem. I work with Oracle 8.05. The users more than 300 .

> > Very often arise blocking, session hang at manipulation of the users to

> >  the same schema. I should them simply kill. But I can not understand,

> > why it occurs.

> > Can to someone it was possible to write inquiry, which allows to fix

these


> > locked session also would write down time, during which session

> > Is locked? I shall be grateful, if someone will inform by the experience

>


> Look at v$lock. There are 'held' (who has got the lock) and 'requested'

> (who wants it) columns.  There is also a time for how long someone has

> had or has been waiting for the lock.

>


> Use the sid column to link it back to v$session

>


> hth

> connor

> --

> ==============================

> Connor McDonald

>


> http://www.oracledba.co.uk

>


> "Some days you're the pigeon, some days you're the statue..."