Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> db file sequential read, where does it read to?
9.2.0.5 Ent Ed AIX5L
I've got a few long running processes that are all performing full table scans and they are waiting on db file % reads. When a file read is performed, is it reading the blocks into the buffer and then on to the user or does it just dump them straight out to the user? What I'm getting at is, Could these table scans be aging each other's blocks out of the buffer and thus causing more file reads? I guess if I could do away with the table scans in general that would solve my problem though...
I hope that wasn't too confusing. Received on Wed Nov 01 2006 - 15:28:20 CST
![]() |
![]() |