Disk Space Transaction wait event

From: Robert Chung <robertch_at_mindspring.com>
Date: Sun, 25 Feb 2001 04:55:07 GMT
Message-ID: <3a998f5b.306832311@198.99.146.10>

I am trying to import several export files at the same time to a empty Oracle 8.1.6 database running on Sun Solaris. However, these import sessions are running absolutely slow. . . They are mostly waiting on Disk Space Transaction wait event. Does anybody know how to alleviate it? Thank you in advance

DB import sessions are waiting on "Disk Space Transaction" wait event.

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


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

MODE_REQUESTED                           LOCK_ID1


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

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

LOCK_ID2

---

             35              16 Disk Space Transaction     Exclusive
Exclusive                                0

0

             26              16 Disk Space Transaction     Exclusive
Exclusive                                0

0

             23              16 Disk Space Transaction     Exclusive
Exclusive                                0

0

             14              10 Disk Space Transaction     Exclusive
Exclusive                                0

0

             12              10 Disk Space Transaction     Exclusive
Exclusive                                0

0

             10              10 Disk Space Transaction     Exclusive
Exclusive                                0

0

             SID SEQ# EVENT

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


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

P1TEXT
P1 P1RAW

---

• -------- P2TEXT P2 P2RAW

  ---

• -------- P3TEXT P3 P3RAW WAIT_TIME

  ---

• -------- ---------------- SECONDS_IN_WAIT STATE
• ------------------- 10 31,198 enqueue name|mode 1,398,013,958 53540006 id1 0 00 id2 0 00 0 37 WAITING

              12 49,842 enqueue name|mode
1,398,013,958 53540006
id1
0 00
id2

0 00                      0
             157 WAITING

              16           10,365 enqueue

name|mode
1,398,013,958 53540006
id1
0 00
id2

0 00                      0
              17 WAITING

              35           13,258 enqueue

name|mode
1,398,013,958 53540006
id1
0 00
id2

0 00                      0
             136 WAITING

              26           22,964 enqueue

name|mode
1,398,013,958 53540006
id1
0 00
id2

0 00                      0
              74 WAITING

              23           33,865 enqueue

name|mode
1,398,013,958 53540006
id1
0 00
id2

0 00                    220
              43 WAITED KNOWN TIME

              14           34,253 enqueue

name|mode
1,398,013,958 53540006
id1
0 00
id2

0 00                      0
             168 WAITING

7 rows selected. Received on Sat Feb 24 2001 - 22:55:07 CST