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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
