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

From: Joel Garry <joel-garry_at_home.com>
Date: 16 Jun 2005 14:05:55 -0700
Message-ID: <1118955955.696571.89820@g43g2000cwa.googlegroups.com>

dominica_at_gmail.com wrote:
> Hi All,
>
> Do anyone or any good site has:
>
> I need to find a better lock monitoring
> scripts to get segment info, etc.

The 9iR2 OEM has a pretty Lock Manager tool. Works fine with 8i, or tells you if some feature is unavailable. Shows the rowid and what's blocking who, also has a chart of blocking/locking.

--
@home.com is bogus.
Glad that earthquake didn't bring down the computer while I was writing
this.  http://earthquake.usgs.gov/recenteqsUS/Quakes/ci14155252.htm

Received on Thu Jun 16 2005 - 16:05:55 CDT