v$sql.disk_reads versus v$sql.physical_read_requests
From: Walker, Jed S <Jed_Walker_at_cable.comcast.com>
Date: Fri, 7 Jun 2013 17:03:59 +0000
Message-ID: <BAA6E28B6241F046AED1E62D8697516C6F6C279F_at_COPDCEXMB08.cable.comcast.com>
I was looking over v$sql and noticed it has disk_reads and physical_read_requests. I couldn't tell from the docs exactly what the difference is. I'm guessing disk_reads is the number of disk reads requested, and physical_read_requests is how many reads were actually required from the disk (maybe because of diffs in db block size and disk block size?) Curious if anyone knows for certain?
Date: Fri, 7 Jun 2013 17:03:59 +0000
Message-ID: <BAA6E28B6241F046AED1E62D8697516C6F6C279F_at_COPDCEXMB08.cable.comcast.com>
I was looking over v$sql and noticed it has disk_reads and physical_read_requests. I couldn't tell from the docs exactly what the difference is. I'm guessing disk_reads is the number of disk reads requested, and physical_read_requests is how many reads were actually required from the disk (maybe because of diffs in db block size and disk block size?) Curious if anyone knows for certain?
thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 07 2013 - 19:03:59 CEST