Title: Question with lock script - phantom objects
Hi all,
I am using following script to see locks in the DB. Do you see any problems with it?
cut here =
connect / as sysdba
set linesize 200 feedback off heading on pagesize 100
column sid
The script as such works, but I do not like user scripts
accessing objects owned by SYS directly. I normally use
modified version of utlockt.sql in which dba_locks_temp
and lock_holders are global temporary tables in my schema
which do not get dropped re-created every time.
On Mon, 2003-10-06
Raj,
Are you certain that in all the cases id1 is an obj#? Its meaning depends on the
type of lock. An unfortunate coincidence might make it match an obj# when it is
actually something else.
HTH
SF
- --- Original Message --- -
From: Jamadagni, Rajendra
[EMAIL PROTECTED]
To:
Title: RE: Question with lock script - phantom objects
MG,
the one you mention is slow... that's why this script.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
PROTECTED]
Date: 2003/10/06 Mon PM 12:24:27 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Question with lock script - phantom objects
MG,
the one you mention is slow... that's why this script.
Raj