db file sequential read, WAITED SHORT TIME
goiyalaMay 28 2012 — edited May 28 2012All
i am running a query which is doing hash outer join. i see
INST_ID SID EVENT P1TEXT P1 P2TEXT P2 P3TEXT P3 WAIT_CLASS SWAIT STATE
------- --- ------------------------------ -------- --- ------- ---- -------- --- --------------- ------ -------------------
1 347 db file sequential read file# 35 block# 1323384 blocks 1 User I/O 701 waiting short time
it runs one query , but accessing is not changing and it stayed on this block for 701 secs. i checked execution also . it is not increasing.
why it is taking this much time for accessing 1 block . machine load is 2 . cpu is 70% idle.
Any idea of how to diagnose this ?