dba_waiters.lock_type = "Disk Space Transaction" - significance?

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 14 Sep 2001 19:33:10 -0700
Message-ID: <F001.0038F941.20010914193018@fatcity.com>

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 Received on Fri Sep 14 2001 - 21:33:10 CDT