Skip to content

Oracle 19c

Oracle Database Row Archiving

In a recent customer project, I was suffering to delete millions of rows from a LOG table. Removing 3 months of data took more than 30 minutes with the best optimization possible. After a while, I remembered that a very nice oracle feature existing since Oracle 12cR1 enables us to archive rows automatically. Let’s me explain you how it works:… 

Configure Oracle DB for using Large Pages on AIX

When it comes to deploying a new Oracle infrastructure, 90% of it is implemented on Linux. This makes sense, because Oracle runs very stable and performant on Linux and it is also Oracle’s own development platform. But since variety makes life interesting, I recently had the privilege to deploy a new Oracle environment on AIX for a customer.AIX is not… 

A few words about the good to know MAX_IDLE_BLOCKER_TIME

The increasing popularity of tools like SQL Developer and Toad, sometimes comes hand in hand with an increase of stuck sessions.This is especially seen in cases where: User A does a change (neither committed nor rolled back). Then, switches to another task, or even leaves for lunch. Then, User B updates the same row and stays there, stuck for hours.… 

Why do we still have HEIGHT BALANCED Histograms and how to get rid of them?

A customer, who is on 19c with his Oracle databases asked me recently why he still has Height Balanced Histograms in his database? E.g. In 12.1. Oracle introduced Top Frequency and Hybrid Histograms, which should replace Height Balanced histograms. There are 2 main reasons why Height Balanced histograms may still be there: 1. Top Frequency and/or Hybrid histograms are disabled… 

Important DBCA Parameter if you plan to use Storage Snapshot Cloning in ASM

I am currently working on a customer project to create database clones using storage snapshots. The advantages are obvious, because using a storage snapshot as a clone not only saves space, but is also extremely fast compared to a full clone. This post is not about explaining in detail how to implement the snapshot clone technically, but it should point… 

How to configure Linux Server to run Oracle Database 19c on Persistent Memory

Introduction to Persistent Memory In the last few years, storage media have become more and more advanced and faster. Today, SSD disks are almost standard as storage and if an Oracle database really has an I/O critical workload, nvme storage is often used. The latest evolution in database storage is persistent memory which improves latency and I/O throughput compared to… 

Statspack with Oracle Database 19c and Multitenant

Introduction When it comes to performance analysis on Oracle databases, everybody think about Diagnostic Pack. This is a very complete tool and it brings much more metrics than a DBA can analyze. But there is a big drawback with this tool: it’s not included in Standard Edition and it’s an option with Enterprise Edition. If you don’t have this tool,… 

Move a PDB from a server to another one using NFS

Introduction Multitenant brings new possibilities regarding Oracle databases, and one of them is to move a database from a container to another quite easily. When containers are on the same server, it’s very easy, but when the containers are on different servers, you will need to use a database link or an RMAN restore. But there is also another solution… 

5 things that aren’t true about RMAN

Introduction RMAN backups are not a hot topic today. This is because it didn’t evolve that much in 12c/18c/19c, and most of the databases are now protected by a good backup strategy since years, and no changes are needed. Furthermore, Disaster Recovery solutions are more and more deployed, and all the flashback technologies embeded in the database are well known.… 

Get prepared to move your Oracle databases to OCI

Introduction Cloud often raises in the top 3 solutions when thinking about Oracle infrastructure renewal. For obvious reasons: you do not need to buy any server, platform is already available, you pay as a subscription, you drastically reduce time to go to production and you can scale up and down. Oracle Cloud Infrastructure, or OCI, is a Cloud provider you… 

Configuring ODBC : SQLServer Access From Oracle

By Mouhamadou Diaw Sometimes you need to access to your SQLServer from your Oracle database. There is many ways and tools to do this. In this blog I am describing how to perform this task using ODBC. The configuration is below -Oracle Linux server : serverora 192.168.56.41 with Oracle 19 database orcl -Windows server : winrac1 192.168.56.100 with SQLServer Express… 

Oracle Database Appliance KVM Virtual Instance on ODA 19.12

By Mouhamadou Diaw KVM virtualization uses a kernel-based virtual machine (KVM) to create a virtualized environment for your Linux applications.In this blog I want to share some tasks I did at a client. The client is using ODA 19.12. The databases are created on the bare metal and for the applications, we decide to create virtual machines. What do I…