explain plan Archives

Handy Oracle support notes

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

DOP and explain plan notes

Aug042016Freek D'Hooge12c, cbo, explain plan, oracle, parallel query

Earlier this week I was discussing some parallel server parameters with a client, when I noticed something strange. It looked like Oracle was upholding the parallel slave limits set in the parallel_degree_limit parameter, while the parallel_degree_policy was set to manual. According to the documentation, this parameter should not be active with the parallel_degree_policy set to…

Tag: explain plan

Handy Oracle support notes

DOP and explain plan notes