-
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?
-
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?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Check this metalink note 334822.1.
-
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
-
Look for a lock on the affected table or for a Library Cache Lock.
Somebody is preventing Oracle to get there.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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.
"What is past is PROLOGUE"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|