Oracle 12.2 RMAN PARALLELISM benchmarks in Amazon AWS

Recently I decided just to test the behavior of changing the parameter PARALLELISM (1-40) using RMAN backups under different storage types in Amazon AWS and check the results. Just a few things before start just to refresh some concepts regarding RMAN. Usually backup bottlenecks are not around CPUs. Generally speaking it’s the ability to write… Continue reading Oracle 12.2 RMAN PARALLELISM benchmarks in Amazon AWS

Advertisements

Test case using SGA_MIN_SIZE in Oracle 12.2

I decided to do a test case regarding this new parameter to have a better understanding and I could see some interesting results. So check it out and make your own conclusions The sga_min_size is set at PDB level and it guarantees the specified SGA size for the PDB. Before start let’s check what Oracle documentation… Continue reading Test case using SGA_MIN_SIZE in Oracle 12.2

Recommendations for the alternative Standby Database in Oracle Standard Edition (11.2.0.4)

It’s true that we shouldn’t consider DR solution using the manual Logging Shipping process in Standard Edition but we also know that Oracle Enterprise Edition is very expensive 🙂 In this article we have words like unrecoverable, nologging, logging and force logging so if you're not familiar with this words maybe you should read The… Continue reading Recommendations for the alternative Standby Database in Oracle Standard Edition (11.2.0.4)

The misunderstanding of RMAN BASIC compression in Oracle 12c SE2

I saw few questions over the Internet regarding the usage of the BASIC compression algorithm in Oracle 12c (if can / can’t be used in SE2) so I’ve decided to write about it. I might agree that sometimes Oracle documentation couldn’t be explicit enough in some aspects but let’s try to clarify this grey area regarding… Continue reading The misunderstanding of RMAN BASIC compression in Oracle 12c SE2