I should have added:
The timeout I describe was as long as 10 minutes before I tuned it. If
you`re not that patient you may think it`s not working where in fact it
does.
--
Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove zulu from my address
"Syltrem" <syltremzulu_at_videotron.com> a écrit dans le message de news:
4Ib79.8638$H67.47262_at_tor-nn1.netcom.ca...
> > 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..."
>
>
Received on Fri Aug 16 2002 - 13:55:41 CDT
