RE: Library cache lock using monitoring tool

From: Gogala, Mladen <MGogala_at_allegientsystems.com>
Date: Fri, 17 Dec 2004 16:46:02 -0500
Message-ID: <D42C14B2E3F2B74DB41D5B6B2E2B992F01931FBD@pegasus.lawaudit.com>

TOAD may be truncating plan_table, which is not a really cool Idea, ever since PLAN_TABLE has become a temporary table.
--

Mladen Gogala
Ext. 121

-----Original Message-----

From: Mike Schmitt [mailto:mschmitt_at_uchicago.edu] Sent: Friday, December 17, 2004 4:41 PM
To: Oracle-L-freelists
Subject: Library cache lock using monitoring tool

Hi all,

I am writing about a strange problem I am seeing in a 9204 database. There are only 2 sessions in the database (session A is a load process, the second session was me logged in as the system user using TOAD). Somehow TOAD is locking out session A when it is trying to do an index rebuild in another schema (might lock it for everything, I don't know).

---

---

  OBJECT_ID

---

user_B
PLAN_TABLE
      36148

user_B
ADDRESS
      34809

Is the something else I should be looking at here?

[Mladen Gogala]

Another tool?

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 17 2004 - 15:41:36 CST