FAQ
run catblock.sql to create dba_blockers and dba_waiters
@?\rdbms\admin\catblock.sql

Original Message -----
To: "Multiple recipients of list ORACLE-L"
Sent: Friday, August 29, 2003 01:54
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/Claritas_at_claritas.com
Date: 2003/08/28 Thu PM 04:14:26 EDT
To: Multiple recipients of list ORACLE-L
Subject: How to find the session holding the library cache pin.


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 users are accessing the
application...and then complained that his session is just sitting in
idle
state....

I queried the v$session_wait and found that his session is waiting for
the
library cache pin....question is how to tell which session is holding
the
enqueue?

Thanks in advance for your help.

Murali.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Murali_Pavuloori/Claritas_at_claritas.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: rgaffuri_at_cox.net

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 4, '03 at 8:04p
activeSep 4, '03 at 8:04p
posts1
users1
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase