Re: What value Oracle uses for db_cache_size when making decision on direct path reads if db_cache_size isn't set?

From: Mark D Powell <>
Date: Tue, 19 Aug 2014 10:14:15 -0700 (PDT)
Message-ID: <>

I thought the question was what percentage of the db_cache_size would a table need to be for direct reads to be performed rather than the physical IO size that would be used for the direct read?
- -

I have no idea what the answer is and I wonder if rather than being a set percentage of the allocated buffer cache if the current utilization of the cache by concurrent processes also figures into the calculation.
- -

Mark D Powell Received on Tue Aug 19 2014 - 19:14:15 CEST

Original text of this message