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 <markp28665_at_gmail.com>
Date: Tue, 19 Aug 2014 10:14:15 -0700 (PDT)
Message-ID: <0fedd8d2-4abb-4f70-b9fc-2398c5a1a2b5_at_googlegroups.com>
Date: Tue, 19 Aug 2014 10:14:15 -0700 (PDT)
Message-ID: <0fedd8d2-4abb-4f70-b9fc-2398c5a1a2b5_at_googlegroups.com>
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