run catblock.sql to create dba_blockers and dba_waiters
@?\rdbms\admin\catblock.sql
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 29, 2003 01:54
> dba_blockers
>
> this doesnt install by default. i cant remember which script runs
this is from metalink
HOW TO FIND THE SESSION HOLDING A A LIBRARY CACHE LOCK
--
Common situations:
* a DML operation that is hanging because the table which is accessed is
currently
undergoing changes (ALTER TABLE). This may take quite a long
Murali:
After identifying a LC pin wait in v$session_wait, use
dba_lock_internal (it shows DDL/DML Locks, LC Locks,
Latch Locks, etc)
select to_char(SESSION_ID,'999') sid ,
substr(LOCK_TYPE,1,30) Type,
substr(lock_id1,1,23) Object_Name,
substr(mode_held,1,4) HELD, substr(mode_requested,1,4)
RE
Murali:
After identifying a LC pin wait in v$session_wait, use
dba_lock_internal (it shows DDL/DML Locks, LC Locks,
Latch Locks, etc)
select to_char(SESSION_ID,'999') sid ,
substr(LOCK_TYPE,1,30) Type,
substr(lock_id1,1,23) Object_Name,
substr(mode_held,1,4) HELD, substr(mode_requested,1,4)
RE
Take a look at Metalink note 122793.1, HOW TO FIND THE SESSION HOLDING
A LIBRARY CACHE LOCK.
At 12:14 PM 8/28/2003 -0800, Murali_Pavuloori/[EMAIL PROTECTED] wrote:
Gurus:
One of the developers has changed his java code and wants to load the class
into the db. He did this on production db while us
$ORACLE_HOME/rdbms/admin/catblock.sql
--
Mladen Gogala
Oracle DBA
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, August 28, 2003 4:24 PM
To: Multiple recipients of list ORACLE-L
dba_blockers
this doesnt install by default. i cant remember which script runs it. check
metalink.
Murali,
Running this should help in identifying the object being locked and the SID
holding that pin.
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO deserve
Click on 'http://www.needhim.org' for Grace and Mercy t
dba_blockers
this doesnt install by default. i cant remember which script runs it. check metalink.
warning... its a VERY slow view.
>
> From: Murali_Pavuloori/[EMAIL PROTECTED]
> Date: 2003/08/28 Thu PM 04:14:26 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: How t