Re: consistent read and LIO question
From: mathewbutler <mathewbutler_at_yahoo.com>
Date: Fri, 15 May 2009 02:13:40 -0700 (PDT)
Message-ID: <3d808749-6035-49b2-a311-bc8468595178_at_e24g2000vbe.googlegroups.com>
If I read your trace correctly it shows 5 consistent reads taking place, but two of these didn't find the required blocks in the cache and therefore had to read from disk via 'db file sequential read'.
Date: Fri, 15 May 2009 02:13:40 -0700 (PDT)
Message-ID: <3d808749-6035-49b2-a311-bc8468595178_at_e24g2000vbe.googlegroups.com>
If I read your trace correctly it shows 5 consistent reads taking place, but two of these didn't find the required blocks in the cache and therefore had to read from disk via 'db file sequential read'.
If so, it looks like v$sysstat only records LIO that do not initiate a physical read.
Mathew Butler Received on Fri May 15 2009 - 04:13:40 CDT