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,...