parameter Archives

Why DB_BIG_TABLE_CACHE_PERCENT_TARGET was a good solution

Jun222017Geert De Paep12c, buffer cache, certified master, database, oracle, parameter

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

Handy Oracle support notes

Mar032017Pablo Hendrickx12c, buffer cache, cloud, data appliance, database, Exadata, explain plan, linux, materialized views, migration, oda, opatch, ORA-07445, oracle, parallel, parallel query, parameter, partitioning, patching, pga, pga_aggregate_limit, PSU, rac, security, storage, support, upgrade

Sometimes you just need one or more MOS / Oracle support notes quickly... Don't worry, we've got your back. We created a list of useful notes which we ourselves use every day. If you are already logged in to My Oracle Support you will immediately be redirected to the note. We are constantly updating this...

Tag: parameter

Why DB_BIG_TABLE_CACHE_PERCENT_TARGET was a good solution

Handy Oracle support notes