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 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 ]
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 126.96.36.199. 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 ]
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 ]
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 ]
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. 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 ]
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
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 188.8.131.52
Please find the new September versions of:
Oracle 184.108.40.206 preupgrade.jar – build 17
There’s issue with “creating directories” int he build 17 version – please use build 18 instead!
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 ]
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.
Worst post-conference blues ever?
Actually my worst post-conference blues wasn’t after POUG2018.… [ Read More ]
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 ]
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
You can download it from oracle.com and eDelivery:
I‘m back from vacation. With 900 or so emails in my inbox. And messages on LinkedIn and Twitter, comments on the blog etc. So plenty of things to do for the next days. The event I’m really looking forward is my upcoming visit of the POUG – Pint with the Oracle User Group in Sopot, Poland.… [ Read More ]
I posted several blog posts about Unified Auditing in the past. And recently a large customer in the UK alerted me about their upgrades with PDBs from 12.1 to 12.2 taking much longer when Unified Auditing policies were enabled. It looks like as if Unified Auditing policies can slow down the upgrade.… [ Read More ]
I really don’t want to turn this blog into an accumulation of issues and flaws. But as I explained many times before, the blog for me is also a way to dump information I likely will need the sooner or later again.
We had several discussions on the internal mailing lists the other day about cloning with Pluggable Databases in Oracle 18c (or 220.127.116.11). And I blogged about this topic a while ago but realized I may need to refresh this a bit.