RE: direct path read & db_file_multiblock_read_count
From: Fergal Taheny <ftaheny_at_gmail.com>
Date: Sat, 26 Oct 2013 00:07:29 +0100
Message-ID: <CAOuMUT5278r9omaruNv-+JXQHB043UjeDcN4wew1zRiR9JUgxA_at_mail.gmail.com>
Hi Amir,
Yes I know direct path reads don't go through the buffer cache but I think I read that a full table scan can be a mixture of direct path reads and logical reads if some blocks are cached already.
Date: Sat, 26 Oct 2013 00:07:29 +0100
Message-ID: <CAOuMUT5278r9omaruNv-+JXQHB043UjeDcN4wew1zRiR9JUgxA_at_mail.gmail.com>
Hi Amir,
Yes I know direct path reads don't go through the buffer cache but I think I read that a full table scan can be a mixture of direct path reads and logical reads if some blocks are cached already.
I could be mistaken.
Regards,
Fergal
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Oct 26 2013 - 01:07:29 CEST