Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: locks

Re: locks

From: <TOnions_at_attrs.uk.att.com>
Date: Tue, 19 May 1998 14:16:16 GMT
Message-ID: <6js47g$ci7$1@nnrp1.dejanews.com>


Check out the code depot and hints pages of Oracle Magazines web site (www.oramag.com) There are some locking scripts there one of which includes PID (available from V$PROCESS if you are interested).

In article <6jrbbe$mon$1_at_sloth.swcp.com>,   elufker_at_swcp.com (Ed Lufker) wrote:
>
> Hi:
>
> Does anyone have a script to get the os pid of a process that is
> holding a lock? I've found utllockt.sql which is great for finding the
> locks, but I was wanting to kill the unix process that was holding the
> lock and I didn't have any facility to get the os pid?
>
> thanks in advance for any help
> eddie lufker
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 19 1998 - 09:16:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US