Performance

4+1 Webinars: Upgrade, Migrate, Consolidate to 19c – not only for Australia

Posted on May 11, 2020 by Workshop 2

Actually this weekend Roy and I would have flown from Australia to New Zealand. We planned at least 5 seminars. And we’ll do them in person as soon as conditions allow. If you are not tired yet of all these webinars offered to you, then we have the right offering for you.

4+1 Webinars: Upgrade, Migrate, Consolidate to 19c - not only for Australia

Photo by Carles Rabada on Unsplash

And not only for those of you based in Australia and New Zealand. Singapore, Japan, Korea and other countries in this part of the globe. Roy and I will run for 4+1 Webinars: Upgrade, Migrate, Consolidate to 19c – not only for …

Continue reading...

Unified Auditing policies can slow down the upgrade

Posted on August 28, 2018 by Auditing 0

Unified Auditing policies can slow down the upgradeI 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.

We did some further investigations. See the results below.

Unified Auditing

You find a good number of blog posts explaining how to migrate to Unified Auditing, the performance tweaks in Oracle 12.1.0.2 and some other things:

… Continue reading...

Unified Auditing – Performance Improvements in Oracle 12.1.0.2

Posted on April 19, 2017 by Auditing Performance Tuning Security 10

Unified Auditing got introduced in Oracle Database 12.1.

Unified Auditing - Performance Improvements in Oracle 12.1The downsides of the “old” auditing facilities became obvious when too many users had activities or transactions at the same time leading to audit records being written into AUD$. Contention was a typical issue. The same thing happened when too many users tried to login at the same time. Furthermore protecting the auditing information required Database Vault as there was no default protection available.

This – and some other things – should be remedied by Unified Auditing which is available since Oracle Database 12c. It gets enabled in sort of a “mixed …

Continue reading...

Different Metrics for SPA (SQL Performance Analyzer)

Posted on September 9, 2015 by Performance Tuning Real Application Testing 0

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...

Archives

Categories

Upcoming Events

There are no upcoming events at this time.

Upgrade @YouTube

Blog Stats

  • 2,249,914 hits

Subscribe via Email

Join 4,248 other subscribers

Follow me on Twitter