SPA

Virtual Classroom: Performance Testing Using the Oracle Cloud for Upgrades and Migrations

Register here!

for Mar 17, 2021 – 10:00h CET

Virtual Classroom Web Seminar No.9:

Performance Testing Using the Oracle Cloud for Upgrades and Migrations

Everybody talks “cloud”, but what about the practicalities? We’ve already delivered a full 2-hour talk about how to migrate to the Oracle Cloud (“Move to the Cloud—Not Only for Techies”), and this time we’ll go beyond pure migration. How do you test? What are the best practices? And which special features can you expect in the various cloud deployments? We assume you have on-prem databases, and you either use the cloud for testing only, or …

Continue reading...

3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered

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.

39 We need
Continue reading...

The new Oracle 19c Hands-On Lab is available now for download

Wow, this took a long while. Thanks to my team mate, Data Pump Product Manager Bill Beauregard who went through the complex approval process, the new Oracle 19c Hands-On Lab is available now for download. And in addition, I adjusted the instructions on the blog as well.

The new Oracle 19c Hands-On Lab is available now for download

Photo by Kenrick Mills on Unsplash

What you’ll get …

At first, the download is huge. All together, you will download 13 files summing up to 25GB. When you unzip it, you will get an OVA file. Then you will need to import this appliance into Oracle VirtualBox. The lab will …

Continue reading...

Different Metrics for SPA (SQL Performance Analyzer)

I’m more the command line type of person. Once I’ve understand what’s going on behind the curtains I certainly switch to the GUI-click-click tools. But in the case of Real Application Testing – even though the support via the OEM GUI is excellent – sometimes I prefer to run my procedures from the command line and check my reports in the browser.

Recently Thomas, a colleague from Oracle ACS Support, and I were asking ourselves about the different comparison metrics for the SQL Performance Analyzer reporting We did scan the documentation but we found only examples but no complete …

Continue reading...