DatabasesProtheus slow? Where to look for the cause: database, DBAccess and infrastructure
A no-nonsense guide to isolating Protheus slowness: database, DBAccess or infrastructure? Ready-to-run queries, the telltale signs of each layer and…
secondary_vnic_all_configure.sh
Official Oracle Cloud script that automatically detects and configures all secondary VNICs attached to a Linux VM. Ideal for multihoming,…
OracleOracle DBMS_SCHEDULER vs DBMS_JOB: a single package to manage, pause, and monitor jobs
Introduction Many Oracle environments run two scheduling mechanisms side by side: DBMS_SCHEDULER (modern) and DBMS_JOB (legacy). Each has its own…
OCIOracle Cloud DBCS: backup failure with ORA-28361 on a new PDB without a master key (OPEN_NO_MASTER_KEY)
While migrating a Pluggable Database (PDB) from an on-premise source environment to Oracle Cloud DBCS, we identified a failure during…
OCIMySQL Migration: How to Migrate from AWS Amazon Aurora MySQL to OCI HeatWave MySQL with Minimal Downtime
In this article, we will demonstrate, clearly and practically, how to perform a MySQL database migration with minimal downtime. For…
PostgreSQLUnderstanding the execution plan in PostgreSQL: how to improve the performance of your SQL queries, part 2
Continuing with part 2 of our article on execution plans, we will look at how to analyze and interpret an…
OracleUnderstanding the execution plan in Oracle: how to improve your SQL query performance (part 1)
The power of SQL and the performance challenge One of the great advantages of SQL is its declarative nature. That…
OracleRunning Datapump Export (expdp) on Oracle RDS
In this tutorial, we will explore how to perform a data export using Datapump Export via the DBMS_DATAPUMP API in…