Oracle

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,(…)

Automatic PL/SQL to SQL Transpiler

SQL is a wonderful language and very easy to use. For example you can call a PL/SQL function into a SELECT or WHERE clause and the result of the PL/SQL function is returned into the SQL expression. But when we(…)

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(…)

ODA X10: the new Oracle Database Appliances are already there

Introduction ODA X8-2 series was sold for 3 years, and I would have expected X9-2 series to be on the market for 2-3 years, but I was wrong. ODA X10 series has just been announced. Maybe Oracle has a different(…)

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,(…)

Larry Ellison – Oracle’s Vision for the future

Generative AI changes everything Larry Ellison kicked off his keynote by delving into Artificial Intelligence, particularly focusing on ChatGPT. The phrase is sure to become famous “About a year ago OpenAI demonstrated ChatGPT 3.5 and much to the shock of(…)

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(…)

Las Vegas, from sin city to green city?

Introduction Oracle CloudWorld 2023 will start next week in Las Vegas, and I’m happy to participate in this worldwide event. As a Swiss citizen, when I think of Las Vegas, the first image that comes to my mind is that(…)

Running an Oracle Database 19c on Apple Silicon (Apple Macbook Air M1)

By end of June 2023 Oracle announced the availability of Oracle 19c for the Arm-architecture (aarch64). Consultants and DBAs, who do use a Mac Laptop with Apple Silicon (M1 or M2), have waited quite a long time to(…)

How to apply patch 19.19 on your ODA?

Introduction It’s been several weeks that patch 19.19 is available on ODA. And I finally had the possibility to test it. What’s new? This version brings latest PSUs to database and grid homes, with their bug fixes as usual. It(…)