UKOUG Tech18 : See you there!

It’s time for my (and our) final conference this year: UKOUG in Liverpool. Liverpool? Yeah … the city of The Reds and The Blues (and Sunday is Merseyside derby time). The city of the greatest pop band ever, the Beatles. And well, the city which has an airport you can’t really fly into.… [ Read More ]

Direct INSERTs into HCC tables may be slower since Oracle 12.2

I work with several customers at the moment on their Oracle 12.2/18c “go live” projects. And one of these customers encountered a strange issue when comparing Oracle 11.2.0.4 to Oracle 12.2.0.1/18.3.0: Direct INSERTs into HCC tables may be slower since Oracle 12.2. Actually in this particular case, significantly slower. Read below why this can happen and how the workarounds look like.… [ Read More ]

How long can you provision database version X in the Cloud? – NEW

A few weeks ago I published a blog post about provisioning dates in Oracle Cloud environments for different databases releases. As we did an important update, I rewrite today: How long can you provision database version X in the Cloud? – NEW.

What has changed since the original post?

The key point in the previous blog post was:

“And by end of this calendar year, the option to provision an Oracle 12.2.0.1 instance will go away. [ Read More ]

Oracle Database 18c for AIX, HP-UX and zLinux available

I rarely blog twice a day – but this message is the one a good number of people have waited for quite a while. Oracle Database 18c for AIX, HP-UX and zLinux available for download from eDelivery as of now. The software is not on OTN or oracle.com yet in the usual download section.… [ Read More ]

DOAG Conference 2018 in Nuernberg – Upgrade and AutoUpgrade talk

DOAG Conference 2018 in Nuernberg - Upgrade and AutoUpgrade talkWell, how do I realize it is November already? When I receive my conference pass for DOAG conference. And actually when the first snow falls right on time when I plan to hit the road. Lovely! If you are coming to DOAG Conference 2018 in Nuernberg – Upgrade and AutoUpgrade talk is the one you should see.… [ Read More ]

How to speed up Multitenant CUSTOM database creation

Why has the PDB$SEED such a strange setup?I usually create my container databases for testing with the CUSTOM option of DBCA. That allows me to specify exactly the components I’d like to have – or not. But I realized two things during the CUSTOM creation: It takes very long. And in the alert.log I see resize operations especially with the PDB$SEED during dictionary view creation.… [ Read More ]

Oracle Open World 2018 – Recap, Slides, Impressions – and a BIG THANK YOU!

Oracle Open World 2018 is over since two weeks now. And for me it was the by far busiest OOW ever. We had 4 presentations, 4 labs, 12 customer CVCs, several other customer appointments … and I wouldn’t want to miss a single one. It was a lot of work – but meeting with these customers, the discussions after the talks, at the hallways, at the lab, that is so important for us.… [ Read More ]

Why Release Update Revisions (RUR) are tricky

A while ago we introduced Release Updates (RU) and Release Update Revisions (RUR). And despite the fact that not only we but also well known external experts such as Ludovico Caldara recommend to stay with Release Updates and simply ignore the Revisions, some people use them. There may be reasons for doing so.… [ Read More ]

Oracle Express Edition XE 18c available for download

This was hard work right before Oracle Open World – and you had to wait a very long time. The last Oracle Express Edition we delivered was based on Oracle 11.2.0.2. Not exactly the most modern release these days. And my mates, especially Gerald Venzl, but of course also the involved developers and managers worked hard to have Oracle Express Edition XE 18c available for download.… [ Read More ]

Oracle GoldenGate 18c is finally available

It took a while – and my blog post is a bit late due to OOW as well. But Oracle GoldenGate 18c is finally available since Oct 19, 2018. And it brings Oracle Database 18c support.

Oracle GoldenGate 18c is finally available

You can download it from the usual sources:

The new release includes for the Oracle database:

  • Oracle Database 18c Support
    Capture and Delivery support for Oracle Database 18c, cloud and on-premises
  • Autonomous Data Warehouse Cloud (ADWC) and Autonomous Transaction Processing (ATP) Support
    Easily connect to ADWC and ATP to deliver transactions
  • Identity Column Support
    Simplified support for handling identity columns in the Oracle Database
  • AutoCDR Improvements
    Support for tables with unique keys (UK)
  • Composite Sharding
    Support for multiple shardspaces of data using consistent partitioning
  • In-Database Row Archival Support
    Support for compressed invisible rows

More Information

[ Read More ]

Why is the October Patch Bundle from July?

Strange blog headline, isn’t it? Intentionally. Peter Lehmann mailed me a question – and asked more or less: Why is the October Patch Bundle from July? Sounds strange? It is strange …

Strange notation

Peter wanted to download the most recent patch bundle for Grid Infrastructure from October. And he found patch 28507693:

But he was wondering about the headline having the date of October 18, 2018 together with JUL 2018.… [ Read More ]

To which release should you upgrade to? Plus: Extended Support?

To which release should you upgrade to? Plus: Extended Support?

A few days ago I blogged about the Current Support Status for Oracle Database Releases. And you’ve sent several questions to me. Some asked about clarification to which release should you upgrade to? Plus: Extended Support questions were quite frequent. So let me clarify this previous blog post a bit.… [ Read More ]

OOW 2018: How to Migrate to Oracle Autonomous Database Cloud

OOW 2018: How to Migrate to Oracle Autonomous Database Cloud

And last but not least our forth talk at OOW 2018: How to Migrate to Oracle Autonomous Database Cloud on Tuesday, Oct 23 at a fairly late slot at 5:45 p.m. (or 17:45h) as well in Moscone West 3004.

What is this talk all about?

It’s about the Oracle Autonomous Database cloud.… [ Read More ]

Current Support Status for Oracle Database Releases

Yesterday a former colleague from the UK pointed me to a very old blog post about the fact that no patches will be produced for Oracle 11.2.0.3 anymore. Which is a true fact. But it reminded me that it may be time for an overview on the current support status for Oracle database releases as of October 2018.… [ Read More ]

OOW 2018: Cloud Migration from AIX to ExaCC – for DBAs and managers

OOW 2018: Cloud Migration from AIX to ExaCC - for DBAs and managers

Yes, OOW starts next week. And I’d like to introduce the third of our 4 talks. And let me say upfront about this talk at OOW 2018: Cloud Migration from AIX to ExaCC – for DBAs and managers. This is not the usual “cloud” talk 🙂 The official title is: Oracle Database Cloud Migration: Fast, Simple, Universal.… [ Read More ]

OOW 2018: Upgrade to Oracle 18c – Live and Uncensored

OOW 2018: Upgrade to 18c - Live and Uncensored

Less than two weeks until the potentially busiest Oracle Open World conference I’ve ever attended. The schedule is filled up already and closed down. And I’m pretty sure I will need time off afterwards to relax and recover. But I’m looking forward to our annual big event in San Francisco. To make it as exciting as possible for you we are very happy to have high profile speakers with us in all our talks.… [ Read More ]

New Oracle Database Upgrade Lab for Oracle 18.3.0

New Oracle Database Upgrade Lab for Oracle 18.3.0

Our new and updated Oracle Database Upgrade Hands-On Lab for Oracle 18.3.0 is finally live and can be downloaded via this link:

What’s new?

Of course, Oracle 18.3.0 is inside to upgrade to. But we changed the entire instructions set a bit.… [ Read More ]

OOW2018: The new AutoUpgrade for the Oracle Database

As I wrote the other day, OOW 2018 is not too far away anymore. And if you’d like to see something really new, something which can really really ease your database upgrades in the near future, then you may visit our first talk right on Monday morning at OOW2018: The new AutoUpgrade for the Oracle Database.… [ Read More ]

OOW 2018 is coming – and we’ll have 4 talks and 4 labs

OOW 2018 is coming - and we'll have 4 talks and 4 labs

OOW 2018 is coming – and we’ll have 4 talks and 4 labs. We are excited and look forward to a very busy OOW. And those who say, OOW is marketing only, please come by to our talks and visit our labs to find out that we don’t do marketing.

OOW 2018 is coming – and we’ll have 4 talks and 4 labs

Oracle Open World 2018 will be a busy conference for us.… [ Read More ]

Where does the database link SYS_HUB come from?

This blog lives a lot from customer’s feedback and updates. And these days, Nicolas Jardot from dbi-services in Switzerland sent me an email asking: Where does the database link SYS_HUB come from? And if he can delete it or if it has any deeper purpose. Neither Google nor MOS reveal a lot of useful information

Where does the database link SYS_HUB come from?

Where does the database link SYS_HUB come from?

[ Read More ]

Improved preupgrade.jar for Oracle 12.2 and 18c

My team mates are really quick. We received an information early this week about a missing or wrong DV check in the preupgrade – and they implemented it within a day or so. The September 2018 version of the improved preupgrade.jar for Oracle 12.2 and 18c is available for download.

Improved preupgrade.jar for Oracle 12.2 and 18c

What’s new in this version:

  • It adds a recycle bin check when the autofixup for dictionary statistics is run
  • And it updates DV_AUDIT_CLEANUP  to 11.2.0.4

Improved preupgrade.jar for Oracle 12.2 and 18c

Please find the new September versions of:

  • Oracle 12.2.0.1 preupgrade.jar – build 17
    • There’s issue with “creating directories” int he build 17 version – please use build 18 instead!
[ Read More ]

Office Hours: Upgrade and Migrations – September 20, 2018

It’s time for the next Office Hours: Upgrade and Migrations – September 20, 2018. This time Roy and Bill will run it as I’m traveling. And they’ve set it on purpose to a convenient time for the Americas. Roy has prepared a few slides upfront – and then it’s your time for questions.… [ Read More ]

Post-Conference Blues – or 5 days after POUG1018

Have you ever had a post-conference blues? This is the mood which makes you feel like sitting in a dark cage surrounded just by nothing as silence. And I’m still in post-conference blues – or 5 days after POUG2018.

Post-Conference Blues - or 5 days after POUG1018Worst post-conference blues ever?

Actually my worst post-conference blues wasn’t after POUG2018.… [ Read More ]

Oracle 12.2 and higher: Set _cursor_obsolete_threshold to old default

Sometimes development groups change default parameter settings because it fits well for a specific feature. This has happened with _cursor_obsolete_threshold in Oracle Database 12.2. But there’s now an official recommendation for Oracle 12.2 and higher: Set _cursor_obsolete_threshold to old default.

What is _cursor_obsolete_threshold?

First of all, this is obviously an underscore parameter.… [ Read More ]

Oracle Database 18c on-prem for MS Windows is available

I know it got delayed a bit. But there’s a good reason for the delay. In addition, my post is a bit late as well but I was on vacation. Anyway, you can download it since Aug 22, 2018. Oracle Database 18c on-prem for MS Windows is available.

Oracle Database 18c on-prem for MS Windows is available

Oracle Database 18c on-prem for MS Windows is available

You can download it from oracle.com and eDelivery:

Start here with the Oracle 18c on Windows Installation Guide.… [ Read More ]