Databases Reference
In-Depth Information
The parameter
DB_CACHE_ADVICE
set to
ON
allows us to obtain, in step 6, an estimate of
performance varying the Buffer Cache size for 8K and 16K database block sizes. We can see
the results obtained in the following screenshot:
Observing the
ESTD_PHYSICAL_READS
column, increasing the Buffer Cache for 8K database
blocks over 112 Megabytes doesn't enhance the performance of the system, so we can use
this value to set the appropriate size for the Buffer Cache.