local write wait

Printable View

08-23-2007, 03:54 AM
tabreaz

local write wait

Truncating table takes long time and I have got this wait event "local write wait".

How one can come over with this wait event?
08-23-2007, 07:05 AM
PAVB

please give us three pieces of information.

How many rows do you have in your table?
How large your table is (GB)?
How many extents does your table has?
08-23-2007, 09:34 AM
malay_biswal

Check this metalink note 334822.1.
08-23-2007, 02:52 PM
tabreaz

Table has only two rows with less then 1MB
I was facing a problem with truncate command in a application, so i created test table with 2 rows & truncate command on table takes more than 4 minutes
08-23-2007, 06:09 PM
PAVB

Look for a lock on the affected table or for a Library Cache Lock.
Somebody is preventing Oracle to get there.
08-23-2007, 06:56 PM
dbasan

Quote:

Originally Posted by tabreaz

Table has only two rows with less then 1MB
I was facing a problem with truncate command in a application, so i created test table with 2 rows & truncate command on table takes more than 4 minutes

When you execute truncate, did you check the I/O on your disks.

I think there could be a problem here. when you do this, it is waiting for the checkpoint to happen locally where the I/O is preventing and DBWR is busy. There is also chance for the log buffer parallel write delay.