Database Administration & Monitoring

Speed up datapump export for migrating big databases

Introduction Big Oracle databases (several TB) are still tough to migrate to another version on a new server. For most of them, you’ll probably use RMAN restore or Data Guard, but datapump is always a cleaner way to migrate. With(…)

Oracle 20c Data Guard : Validating a Fast Start Failover Configuration

By Mouhamadou Diaw In Oracle 20c, we can now validate a Fast Start Failover configuration with the new command VALIDATE FAST_START FAILOVER. This command will help identifying issues in the configuration. I tested this new feature. The Fast Start(…)

Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD

By Mouhamadou Diaw As you may know, Oracle 20c is in the cloud with new features. The one I have tested is the PREPARE DATABASE FOR DATA GUARD. This command configures a database for use as a primary database(…)

SQLNET.EXPIRE_TIME and ENABLE=BROKEN

By Franck Pachot . Those parameters, SQLNET.EXPIRE_TIME in sqlnet.ora and ENABLE=BROKEN in a connection description exist for a long time but may have changed in behavior. They are both related to detecting dead TCP connections with keep-alive probes. The former(…)

odacli create-database extremely slow on ODA X8-2 with 19.5

Introduction ODA X8-2, in the S, M or HA flavour, is the new database appliance from Oracle. But as a brand new product, you can experience troubles due to the lack of maturity. This time, it concerns database creation that(…)

How can Docker help a MariaDB cluster for Disaster/Recovery

Mistakes or accidental data deletions can sometimes happen on a productive MariaDB Galera Cluster and this can be disastrous. There are so many cases I have heard by customers and hereafter are some of the most common: -(…)

Control-M/EM Update ctmuser & emuser DBO password

Introduction For security purposes we sometimes must update the password of our Control M architecture. This task seems to be easy, but you must be careful to update the passwords wherever they are used. Today we will check how to(…)

How SQL Server MVCC compares to Oracle and PostgreSQL

By Franck Pachot . Microsoft SQL Server has implemented MVCC in 2005, which has been proven to be the best approach for transaction isolation (the I in ACID) in OLTP. But are you sure that writers do not block readers(…)

NVMe the afterburner for your database

Over 1 million IOPS (@8 KByte) and more than 26 GByte/s (@1MByte): Read more to see all impressive benchmark figures from a server with 14 NVMe drives and read why this is still not the best you could get...

Should I go for ODA 19.5 or should I wait until 19.6?

Introduction As you may know, Oracle Database 19c is available for new (X8-2) or older Oracle Database Appliances since several weeks. Current version is 19.5. But when you go to the official ODA documentation , it(…)