Why DB_BIG_TABLE_CACHE_PERCENT_TARGET was a good solution
DB_BIG_TABLE_CACHE_PERCENT_TARGET During the preparation of my Oracle DBA 12c Certified Master exam, I learned about the DB_BIG_TABLE_CACHE_PERCENT_TARGET parameter in 12c. This parameter allows you to reserve a certain percentage of the buffer cache for storing large tables. Full table scans on large tables are normally NOT stored in the buffer cache (they also use direct reads,...
Read More