Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> db file sequential read, where does it read to?

db file sequential read, where does it read to?

From: Ben <balvey_at_comcast.net>
Date: 1 Nov 2006 13:28:20 -0800
Message-ID: <1162416499.959529.300730@i42g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US