Man showing question mark on wooden cube. 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...
Category - Oracle
Articles about Oracle technology.
In this article I’ll not go into detail on technical stuff. It will be focused in the news that Oracle presented in the Oracle Cloud Day that was held in Dublin in November 2016. Oracle Enterprise Cloud Strategy This is the model presented by Oracle for Enterprise Cloud Strategy. Up to...
Oracle Standard Edition SE2. Recommendations for the alternative Standby Database.
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...
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...
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...
How Oracle Standard Edition can fit to your business? For the past 20 years as DBA I saw companies taking wrong calls regarding their infrastructure and guess what? This is a recurrent issue until today. Sometimes part of technical experts are not really evolved for any reasons and...
Caught off guard by Oracle licensing? Well you’re not alone. This post will cover things that I’ve needed to check over time to see if there is any “catch” special licensing required for using Oracle components. This document will be a guide for me as well so probably it...