Oracle Team

How to create a Backup Report in EM Cloud Control 13c

This blog describes how to create a backup report in Enterprise Manager 13c.

Paginating Through a Documentum’s Result Set

This blog article shows examples of the pagination DQL hint RETURN_RANGE.

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

How to code better?

Sysadmins are traditionally more operators than developers, they code mainly scripts for automation reasons (shell scripts, Ansible, Terraform, aso). In addition, they can find themselves in situations where they need to analyse code or even decompile programs. Some sysadmins lack(…)

Comparison of support cycles RHEL and Clones

This blog is a comparison about the support periods of RHEL and the RHEL clones like AlmaLinux, Enterprise Linux, Oracle Linux and Rocky Linux and a look back to CentOS. CentOS Stream is a pre release of RHEL, so(…)

plot-ds.py, A Simple Plotting Command-Line Tool (Technical Details)

An utility to generate graphs and statistics based on input data (csv), for performance analysis.

Oracle Database Backup Cloud Service

In a previous blog I demonstrated how to migrate an Oracle database from AWS to Oracle OCI using Data Guard. But what if you want to migrate to the Oracle Cloud, but don’t have a direct connection between the(…)

Unplug/Plug PDB in TDE Environment

By Mouhamadou Diaw In an oracle environment with Transparent Data Encryption (TDE) the transfer of PDB may require additional steps. In this blog we will see some steps which may be required when doing Unplug and Plug  of pluggable(…)