Tuning DB Sequential Reading while inserting
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Tuning DB Sequential Reading while inserting

  1. #1
    Join Date
    May 2008
    Posts
    29

    Tuning DB Sequential Reading while inserting

    INSERT INTO STATE (INSTANCE_NAME, LAST_CHECKIN_TIME,
    CHECKIN_INTERVAL, RECOVERER)
    VALUES
    (:1, :2, :3, :4)


    call count cpu elapsed disk query current rows
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    Parse 3 0.00 0.00 0 0 0 0
    Execute 3 0.00 0.00 0 24 132 3
    Fetch 0 0.00 0.00 0 0 0 0
    ------- ------ -------- ---------- ---------- ---------- ---------- ----------
    total 6 0.00 0.00 0 24 132 3

    Misses in library cache during parse: 2
    Misses in library cache during execute: 1
    Optimizer mode: ALL_ROWS
    Parsing user id: 66

    Elapsed times include waiting on following events:
    Event waited on Times Max. Wait Total Waited
    ---------------------------------------- Waited ---------- ------------
    SQL*Net message to client 4 0.00 0.00
    SQL*Net message from client 4 0.01 0.01
    db file sequential read 318236 0.05 16.75
    db file scattered read 6995 0.08 4.78
    latch: cache buffers chains 5 0.00 0.00


    The above query consumes 99% of total overall db file sequential read wait. and 100% of db file scattered read.

    Gurus, if you could guide me which all areas I need to look into to tune the query .. will be highly appreciated.

    Regards

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    look triggers on state table

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Would you mind in trying/tracing "INSERT INTO /*+ APPEND */ STATE (..." ?
    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.

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