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.
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.
Bookmarks