Thank you for participating in our 4 Database Upgrade to Oracle 19c seminars in the past two weeks. There were over 800 questions during the seminars – and it was a good idea that we prerecorded them. This way, I could answer your questions as it was a more convenient time for me than for Roy. We enjoyed it a lot – and from the feedback I read, most of you enjoyed it, too. Now please read about Upgrade Seminars 2020 – Recap and Videos on-demand below.

Photo by Glenn Carstens-Peters on Unsplash
The Slides
I uploaded all 4 decks to the upgrade blog during each seminar already. You can find them here:
The Videos
As promised, we’d like to share the on-demand videos of all 4 seminars with you. You can access each of them via the below links:
or, if you prefer to access each seminar separately without the need to put in your email address:
- Release and Patching Strategy (Seminar 1)
- AutoUpgrade to Oracle Database 19c (Seminar 2)
- Performance Stability, Tips and Tricks and Underscores (Seminar 3)
- Migration to Oracle Multitenant (Seminar 4)
The Poll
We’ve had a quick poll in each of the seminars as you can see from my previous article after the first two seminars.

Poll Question from Seminar 4: Do you use Oracle Multitenant already?
Actually I expected a result like this. And I guess, it represents the overall situation quite well.
More to come?
Actually, I offered already to additional seminars for late summer or early fall. We would like to do one for all the different migration techniques we couldn’t cover in full details, such as Transportable Tablespaces, Full Transportable Export/Import, Data Pump, Data Guard and Oracle GoldenGate. And Daniel and I are eager to direct you to Migration to the Cloud – For Techies Only. We are working with customers and colleagues on several projects. So we’d like to share our experience with you of course.
Let’s see if the marketing team is willing to run these with us again.
And for those who asked whether we do a similar series for the US/Canada and LAD time zones: Roy is working on this. Stay tuned please.
Now take care and hope to see you soon again!
Further Information and Links
- Slides Download for all 4 seminars
- Seminars 1+2 – A Quick Recap, Download and the Polls
- Virtual Classroom Series – 4 Seminars: Upgrade to Oracle Database 19c
–Mike
Thank you so much for the recordings! I wasn’t able to attend live, due to time zones!
Thanks Diana!
We’ll try to offer it again for US and Latin America time zones again.
Cheers,
Mike
Hi Mike,
I’am testing my update from 12.2.0.1 to 19.7. We using for test a database with 35GB memory on solaris 11 sparc 64 and AMM for automatic memory configuration in oracle.
The upgrade is running without any error.
Now I’am getting different pagesizes(same spfile).
In 12.2.0.1
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
2020-06-20T13:33:47.558102+02:00
8K Configured 5 5 NONE
2020-06-20T13:33:47.558262+02:00
64K Configured 0 0 NONE
2020-06-20T13:33:47.558408+02:00
4096K Configured 4097 4097 NONE
————————————————————————-
In 19.7
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
2020-07-12T13:27:34.432767+02:00
8K Configured 2097158 2097158 NONE
2020-07-12T13:27:34.432894+02:00
I better change to ASMM? Why are this differences, where they come from?
Can I messure different Performance issues with page sizes and when yes how?
Best Regards
Sven Leonhard
Sven,
NEVER use AMM – always use ASMM (with SGA_TARGET and PGA_AGGREGATE_TARGET).
When you use AMM, a lot of things are done differently, not only on the OS side but also in the oracle kernel.
Just don’t use it.
Thanks,
Mike