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

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 15 Jun 2005 21:41:53 -0700
Message-ID: <1118896920.630233@yasure>

dominica_at_gmail.com wrote:
> 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.
>
>
>
> Dominica

Why are any objects being locked? This is Oracle not SQL Server. What is the business case for performing any locking?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Wed Jun 15 2005 - 23:41:53 CDT

This message: [ Message body ]
Next message: DA Morgan: "Re: Anyone use the Automatic Shared Memory Management in 10g"
Previous message: DA Morgan: "Re: 99% IOWAIT with Oracle RAC 10g (10.1.0.4) on Linux"
In reply to: dominica_at_gmail.com: "Re: Any good monitor script for LOCKED object V$LOCK"
Next in thread: Vincent Ventrone: "Re: Any good monitor script for LOCKED object V$LOCK"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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