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
