Re: "direct path read" and "db file sequential read" used for full table scans in 11g
Date: Fri, 31 Aug 2012 09:32:03 -0700 (PDT)
Message-ID: <1346430723.75399.YahooMailNeo_at_web83608.mail.sp1.yahoo.com>
No worries mate :) All good :)
Gaja Krishna Vaidyanatha,
CEO & Founder, DBPerfMan LLC
http://www.dbperfman.com
http://www.dbcloudman.com
Phone - +1-650-743-6060
LinkedIn - http://www.linkedin.com/in/gajakrishnavaidyanatha
Co-author: Oracle Insights:Tales of the Oak Table - http://www.apress.com/9781590593875 Primary Author: Oracle Performance Tuning 101 - http://www.amzn.com/0072131454 Enabling Cloud Deployment & Management for Oracle & Big Data
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> To: Oracle-L List <oracle-l_at_freelists.org> Sent: Friday, August 31, 2012 9:24 AM
Subject: Re: "direct path read" and "db file sequential read" used for full table scans in 11g
Gaja,
I misread your original posting - I thought you were saying that this would happen with direct path reads as well.
It's not difficult to engineer a case where every other block of a table has been loaded into the cache, at which point a (cached) full tablescan would read the other alternating half using single block reads - but if 11g chose to do direct path reads it would still do reads that were generally the 1MB.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com/all_postings
Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543
- Original Message ----- From: "Gaja Krishna Vaidyanatha" <gajav_at_yahoo.com> To: "Oracle-L List" <oracle-l_at_freelists.org> Sent: Friday, August 31, 2012 5:13 PM Subject: Re: "direct path read" and "db file sequential read" used for full table scans in 11g
| Hi Jonathan, Mark et al.,
| My writeup was for a "simple full table scan" (like the example I gave),
just to point out that "db file sequential reads" does occur for full
scans. And yes, I am sure about that. This is true even with nothing else
happening on the database (like delayed block cleanout). I was just
wondering whether a similar phenomenon was being experienced with ADR.
|
| Cheers,
|
| Gaja
|
| Gaja Krishna Vaidyanatha,
| CEO & Founder, DBPerfMan LLC
| http://www.dbperfman.com
| http://www.dbcloudman.com
|
| Phone - +1-650-743-6060
| LinkedIn - http://www.linkedin.com/in/gajakrishnavaidyanatha
|
| Co-author: Oracle Insights:Tales of the Oak Table -
http://www.apress.com/9781590593875
| Primary Author: Oracle Performance Tuning 101 -
http://www.amzn.com/0072131454
| Enabling Cloud Deployment & Management for Oracle & Big Data
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 31 2012 - 11:32:03 CDT