Oracle Team

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

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

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

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

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

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

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

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

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

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