Re: Locking in oracle

On Thu, 4 Feb 1999 17:37:54 +0100, amitabh12_at_my-dejanews.com wrote (in message <79cid1$pc3$1_at_nnrp1.dejanews.com>):
>
> Hello, I was wondering is there any way I can find out who is locking
> me and from what terminal. I am running oracle 8.0

Hi Munish

you can run ?/rdbms/admin/utlblock to get the list of blockers and waiters. You have to run catblock first to create the structures that are needed.

have luck,

-- 
Ronald  -  Unix SA               http://home.wxs.nl/~ronr/professional.html
        -  Oracle DBA            http://www.tresco.nl  
        -  Middleware programmer/
                      designer   mailto:R.Rood_at_tresco.nl