Parameters

New parameters and features in Oracle Database 19.11.0

As usual, as soon as I apply the newest RU, I do also a quick check for New parameters and defaults in Oracle Database 19.11.0.

New parameters and features in Oracle Database 19.11.0

Photo by Roma Kaiuk on Unsplash

New Parameters in Oracle 19.11.0

Based on customer feedback, there is one really big improvement since this RU release. Not only new features but also parameter changes get listed. You will find them in the 19c New Features Guide.

In this RU you will find only 1 new parameter:

drcp_dedicated_opt
The description says “Turn on/off dedicated optimization for DRCP” – and the default is “YES

3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered

Posted on May 2, 2020 by Mike.Dietrich Workshop 2

Thanks a lot to all of you who participated also in our second seminar. Below you find now 3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered.

3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered

Photo by Karl Lee on Unsplash

Your Questions, our Answers for Seminar 2: Upgrade and Performance

I this blog post I answer all questions from the second seminar about AutoUpgrade to Oracle 19c and Performance Stability. Please find the links to the other QAs for Seminar 1 (Release Strategy, Patching and Cool Features) and Seminar 3 (Migration to Multitenant) below in the Links section of this blog post.

We need

Config file for AutoUpgrade – Tweaking init parameters

Posted on July 9, 2019 by Mike.Dietrich AutoUpgrade 2

In the previous blog posts I explained how to generate a sample config file for the AutoUpgrade tool and how to adjust it. Then I gave you an overview about the most important Advanced Options you may want or need to deal with when using the utility. And in the below blog post I would like to show you have you need to edit the Config file for AutoUpgrade – Tweaking init parameters is an important topic.

This is the forth post of a series of blog posts regarding the new AutoUpgrade tool. Please find all the other available …

Oracle 12.2 underscores appear in SPFILE – be aware when you flashback

Posted on September 19, 2017 by Mike.Dietrich Fallback Flaws and Pitfalls 10

I did blog in the past weeks about Fallback Strategies with Flashback Database. But two of my reference customers came across an interesting issue when they tried to fallback: Oracle 12.2 underscores appear in the SPFILE – magically – and prevent the fallback using the existing SPFILE.

Oracle 12.2 underscores appear in SPFILE – be aware when you flashback

In one case it happened during a test, in the other case it happened during a live fallback after the Data Guard Broker has interfered with the upgrade causing real trouble. In both cases the SPFILE sits in ASM.

Both …

SGA_MIN_SIZE in Oracle Database 12.2

Posted on May 8, 2017 by Mike.Dietrich Parameters Single-/Multitenant 0

I did summarize all new init.ora/spfile parameters in Oracle Database 12.2.0.1 a while ago:

New SPFILE parameters in Oracle Database 12.2.0.1

And one caught Roy’s and my attention: SGA_MIN_SIZE.

When we present this new parameter as part of the Multitenant slides in our workshops, some people ask themselves:
“What happens if I oversubscribe such a parameter?” For example, if SGA_TARGET=4G and I have 10 PDBs and define in each of them SGA_MIN_SIZE=500M. Will the 9th and 10th PDB not startup anymore? Or will the 7th PDB already in trouble as the CDB$ROOT will need some SGA portion as …

Parameter Recommendations for Oracle Database 12c – Part II

Posted on March 8, 2016 by Mike.Dietrich Behavior Change Oracle Database 12c Parameters Patch Recommendation 6

Preface

Again, please be advised – the following parameter list is mostly based on personal experience only. Some of them are officially recommended by Oracle

Parameter Recommendations for Oracle Database 12c – Part I

Posted on March 4, 2016 by Mike.Dietrich Oracle Database 12c Parameters Patch Recommendation 5

Preface

Please be advised – the following parameter list is mostly based on personal experience only. Some of them are officially recommended by Oracle Support. Always use proper testing mechanisms.

We strongly recommend SQL Performance Analyzer to …

What happened to the blog post about “12c parameters”?

Posted on February 25, 2016 by Mike.Dietrich Optimizer Parameters Performance Tuning 3

Two weeks ago I published a blog post about Parameter Recommendations for Oracle Database 12.1.0.2. And I took it down a day later. Why that?

I’ve got a lot of input from external sources for the “Parameter” blog post. And I’d like to thank everybody who contributed to it, especially Oracle ACE Ludovico Caldara.

Generally there was a bit of a misunderstanding internally about whether we should “advertise” underscore parameters to cure some misbehavior of the database. In 99% of all cases I’d agree that underscores are not a good solution – especially when it comes …

New (some undocumented) Parameters in Oracle 12.1.0.2

Posted on August 1, 2014 by Mike.Dietrich Oracle Database 12c Parameters 0

Every release offers some surprises – even to myself 😉

Right now Roy and I are in the final steps to refresh our big slide deck to the new layout, but more important, to have Oracle 12.1.0.2 information included as well (were necessary). So I did my usual “compare parameters” query between releases – getting unusual surprises this time.

This is the list of new parameters introduced with the patch set Oracle Database 12.1.0.2. Where applicable I have added the link to the doc.

But as you may recognize not all of them are explained in the doc 😉

DBFIPS_140

Why you shouldn’t set OPTIMIZER_FEATURES_ENABLE

Posted on December 16, 2013 by Mike.Dietrich Optimizer Parameters 6

Roy today answered an interesting question on one of our internal mailing lists. And this reminds me to pick up that piece of information as we see this quite often on customer sites, especially after upgrades or migrations. People set OPTIMIZER_FEATURES_ENABLE (OFE) to revert the optimizer’s behaviour to another pre-current release. That’s what a lot of people think this parameter does.

But in fact this is not true. Even though our documentation states it:

OPTIMIZER_FEATURES_ENABLE acts as an umbrella parameter for enabling a series of optimizer features based on an Oracle release number. For example, if you upgrade your database

Upgrade – and an interesting surprise

Posted on August 10, 2011 by Mike.Dietrich Flaws and Pitfalls Oracle Database 11g Parameters Patch Recommendation 0

Patchset 11.2.0.2 is out there for a long, looong time. But still Roy and me – and unfortunately our customers – sometimes experience some nice surprises after upgrade.

Roy did work on the weekend with a financial institution customer in the US to support them during their go-live on Oracle 11.2.0.2 with several systems. It was well tested and long planned. And overall the whole process went well except for one database (see Roy’s entry below on the change with JOB_QUEUE_PROCESSES in 11.2.0.2).

Yesterday I’ve received a text message from Roy to have a closer look into a service request …

Parameters

New parameters and features in Oracle Database 19.11.0

New Parameters in Oracle 19.11.0

3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered

Your Questions, our Answers for Seminar 2: Upgrade and Performance

Config file for AutoUpgrade – Tweaking init parameters

Oracle 12.2 underscores appear in SPFILE – be aware when you flashback

Oracle 12.2 underscores appear in SPFILE – be aware when you flashback

SGA_MIN_SIZE in Oracle Database 12.2

Parameter Recommendations for Oracle Database 12c – Part II

Preface

Parameter Recommendations for Oracle Database 12c – Part I

Preface

What happened to the blog post about “12c parameters”?

New (some undocumented) Parameters in Oracle 12.1.0.2

Why you shouldn’t set OPTIMIZER_FEATURES_ENABLE

Upgrade – and an interesting surprise

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Follow me on Twitter

Recent Posts