Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

db file sequential read appears in full table scan mode

950046Jul 17 2012 — edited Jul 19 2012
Hi..could some one explain why db file sequential wait event appears continually while table is accessing through full table scan method.

i know sometime even in full table scan mode oracle fetch single blocks if it's segment block.undo block but not contiguously but in my case i haven't seen any other wait event except db file sequential wait event why it is so?.

Addition to this i have used parallel hint also but unfortunately all parallel servers current event is db file sequential event that means even parallel servers are reading single blocks.

Any information would be deeply appreciated
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2012
Added on Jul 17 2012
15 comments
2,705 views