23c

Comparing Data When Migrating Databases With GoldenGate Veridata: Installation Guide

More often than not, migrating a database is not much about moving the data but about ensuring that nothing was lost in the process. In all migration projects, a DBA will have to answer the following question: “Is my target(…)

Oracle Lock Free Reservations

The Oracle 23c new feature Lock Free Reservations allows to break with the traditional locking mechanism. Now multiple concurrent sessions can update the same row without be blocked !!! Let’s see how it works. In the traditional locking mechanism,(…)

SQL FIREWALL

This blog comes to complete the excellent blog written by my colleague Gregory Steulet on the same topic. SQL FIREWALL is a new security layer integrated into Oracle Database 23c. First, we create a admin user for which we(…)

Managing transaction priority in Oracle 23c

Introduction Out of the 300 features encapsulated in the new Oracle 23c database, I’ve chosen to write during the Oracle CloudWord a brief blog post about a feature that particularly caught my attention: Automatic Transaction Rollback. Starting from version 23c,(…)

Oracle to the rescue of MGM with SQL Firewall?

Introduction It is true that it’s a somewhat daring title, and it’s unlikely that SQL firewall has changed anything about the attack that several casinos in Las Vegas suffered last week. However, the opportunity was too good to pass(…)

Installing Oracle 23c Free developer release on Proxmox

Oracle provides an OVA (Open Virtual Appliance) file to install the 23c Free Developer Release on Virtualbox. An OVA file contains metadata and file elements in the Open Virtual Format (OVF) to package and distribute one or more virtual machines.

Migration with Multitenant: how easy it is!

Introduction On Oracle Database, Multitenant feature will be turning 9 in July, but it’s not yet widely deployed as most of the databases are still running on non-CDB architecture. With 19c, Multitenant is now mature and free if you stick(…)