local write wait, rdbms ipc reply, truncate

From: Bobby Durrett <bdurrettccci_at_yahoo.com>
Date: 29 Jan 2004 12:04:58 -0800
Message-ID: <8c63eb2b.0401291204.34c67df4@posting.google.com>

I'm truncating 14000 tables. Five hours later I get this from the V$session_event table:

EVENT                                                  TIME_WAITED
------------------------------------------------------ -----------
latch free                                                      12
rdbms ipc reply                                             738040
local write wait                                            797298
buffer busy waits                                                0
log file switch completion                                     200
log file sync                                               136935
db file sequential read                                      44244
db file scattered read                                           1
SQL*Net message to client                                        8
SQL*Net message from client                                  41045

p.s. I'm running this on a Sun v880. The same process takes 40 minutes on my Dell laptop... Received on Thu Jan 29 2004 - 14:04:58 CST