local write wait

[tabreaz]

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

How one can come over with this wait event?

[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?

[malay_biswal]

Check this metalink note 334822.1.

[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

[PAVB]

Look for a lock on the affected table or for a Library Cache Lock.
Somebody is preventing Oracle to get there.

[dbasan]

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.