-
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
-
look triggers on state table
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|