Skip to content

Oracle Team

Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.

1,009 posts since December 2010

Pluggable Database Snapshots with Oracle 21c

By Mouhamadou Diaw In a previous blog , I talked about refreshable PDB technology which can be used to refresh a target PDB. The target PDB can be in mounted state (mandatory to be refreshed) or can be opened in a read only mode. One application is to use the target refreshable PDB as a master to provide PDB snapshots.… 

Managing Refreshable Clone Pluggable Databases with Oracle 21c

By Mouhamadou Diaw A refreshable clone PDB is a way to refresh a single PDB instead of refreshing all PDBs in a container as in a Data Guard environment. It consists to make a clone of a source PDB and the clone PDB is updated with redo accumulated since the last redo log apply In this blog I did some… 

Character Sets and Oracle 21c PDBs : How It Works

By Mouhamadou Diaw When creating a database in a multitenant environment we must understand how character set works for CDB and PDBS. In Oracle documentation we can find following lines -When the character set of the CDB root is AL32UTF8, PDBs that are plugged into the CDB can have a different character set from the CDB root. PDBs that you… 

Import tnsnames.ora in LDAP directory

This post gives a short intro to directory naming, shows how to import from tnsnames.ora to an LDAP directory. Finally, as an alternative, you get an example how a TNS connection string looks like in ldif file format. LDIF can be used universally to export and importing data to LDAP directories. What is directory naming? In order to connect to… 

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… 

Oracle Partition and Performance of massive/concurrent Inserts

For a customer, I had to check if partitioning improves performance of massive and concurrent inserts. The goal is to execute several Inserts in parallel via dbms_parallel_execute package (my previous blog “parallelize your Oracle Insert with DBMS_PARALLEL_EXECUTE” explains how to use dbms_parallel_execute). The idea is to insert more than 20 millions of rows in 2 tables : One table not… 

Clone Oracle 21c Home

By Mouhamadou Diaw When deploying new Oracle Home on the same server or on a new server, you may use the downloaded Oracle binaries and do an install from scratch as usual. You may then apply any patch you have on your actually Oracle Homes. This may take time. Oracle provides tools to clone an existing Oracle Home with all… 

ODA KVM Machines : Adding a Network Interface on a Virtual Machine

By Mouhamadou Diaw In a previous blog , I was talking about virtual machines on ODA servers. Sometimes it comes that we want to add another network interface for other purpose. In this blog I am describing the main tasks to add a second network interface card on KVM virtual machine. Let’s describe the context I have an ODA X8-2M… 

Oracle 21C Security : diagnostics_control and enable diagnostics

By Mouhamadou Diaw Some debug-events and debug-actions are not safe and should be exposed to users with caution. In previous releases, privilege control for the usage of these diagnostics was not sufficient. With Oracle 21c, regular users can be blocked from using these diagnostics to better support separation of duty. Indeed with Oracle 21c, we have a new mechanism to… 

Parallelize your Oracle INSERT with DBMS_PARALLEL_EXECUTE

One of the challenge of all PL/SQL developers is to simulate the Production activity in a Non Prod. environment like for example different Insert executed by several sessions. Different tools exist like Oracle RAT (Real Application Testing) but under license or you can create your own PL/SQL package using DBMS_SCHEDULER or DBMS_PARALLEL_EXECUTE packages. The aim of this blog is to… 

log4shell: Determine affection, mitigate, example: Oracle Unified Directory

This post is about two security vulnerabilities reported on log4j 2.x framework: CVE-2021-44228, with a base score 10 (of 10 max.) in CVSS version 3.1 risk, and CVE-2021-45046, base scored 9. I will list some ways to determine affection, how to mitigate these vulnerabilities in general and Oracle Unified Directory in particular. Finally, there is a link with updated status to every… 

Dbvisit 10 on Oracle Database Appliance

By Mouhamadou Diaw Dbvisit Standby can also be installed on Oracle Database Appliance (ODA). The installation is the same that on any other Linux box. I did an install of Dbvist 10 on an ODA 19.12 for a customer and in this blog I am describing the on an ODA steps. The configuration is below -The primary server is oda-prod-01…