local write wait
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: local write wait

  1. #1
    Join Date
    Sep 2005
    Posts
    278

    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?

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  3. #3
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    Check this metalink note 334822.1.
    http://www.perf-engg.com
    A performance engineering forum

  4. #4
    Join Date
    Sep 2005
    Posts
    278
    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

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  6. #6
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    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.
    "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
  •  



Click Here to Expand Forum to Full Width