RE: dba_waiters.lock_type = "Disk Space Transaction" - significan

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Mon, 17 Sep 2001 10:54:37 -0700
Message-ID: <F001.00390929.20010917102519@fatcity.com>

Did you try going to v$session_wait for the waiting sessions and see what event exactly are they waiting for? There are brief descriptions of most of the events on metalink . The other good source for version 7 is Anjo Kolk's paper.

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

Sent: Friday, September 14, 2001 11:30 PM To: Multiple recipients of list ORACLE-L

I have a background process running that's doing an analyze on tables, and storing the information in another table. The table in which it's trying to store information has currently reached the maximum number of extents (I'm doing a test to see how the background job handles ORA- errors, so far not very gracefully.)

Now other sessions are "stuck" behind the one session doing the analyze. What could be the causes for this lock_type? ("disk space transaction")

Oracle 8.1.7 - Windows 2000

SQL> select * from dba_waiters ;

WAITING_SESSION HOLDING_SESSION LOCK_TYPE
--------------- --------------- --------------------------
MODE_HELD

---

MODE_REQUESTED

---

LOCK_ID1

---

LOCK_ID2

---

             12 21 Disk Space Transaction Exclusive
Exclusive
0
0

             17 21 Disk Space Transaction Exclusive
Exclusive
0
0

             20 21 Disk Space Transaction Exclusive
Exclusive
0
0

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

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).

Received on Mon Sep 17 2001 - 12:54:37 CDT