Absolutely, if we wanted to make this query run fast, then making the buffer cache bigger would do it. But I was trying to make it go slower ;) – that’s why it was interesting (to me anyway).

Frits,

Yes, in 32 bit days there were distinct advantages to having big file system cache in some cases (like yours).

]]>By: Frits Hooglandhttp://kerryosborne.oracle-guy.com/2011/11/tuning-oracle-to-make-a-query-slower/#comment-74300
Wed, 23 Nov 2011 20:06:56 +0000http://kerryosborne.oracle-guy.com/?p=3760#comment-74300More or less exactly what I encountered some 5-7 years ago. Large solaris machine (at that time; 32GB memory), database user-data size 1-2GB. In order to make the processing go faster, I routinely advised to mount the data filesystems with ‘forcedirectio’….resulting in the database performance getting much times slower, because now it needed to be read from disk, instead from the operating system cache.
]]>By: Gwen Shapirahttp://kerryosborne.oracle-guy.com/2011/11/tuning-oracle-to-make-a-query-slower/#comment-74297
Wed, 23 Nov 2011 19:29:39 +0000http://kerryosborne.oracle-guy.com/?p=3760#comment-74297In short, if you can read 10g table into the OS cache and not the SGA buffer cache, you are not sizing your SGA right.
]]>