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

Advertisements

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