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…
OracleOracle storage structures
How does Oracle store data? The Oracle Database storage structure is designed to be highly efficient and flexible, allowing large…
OracleOracle Database startup/shutdown phases
Starting the Oracle database instance Before users can connect to a database instance, a database administrator must start the database…
OracleViews in Oracle
Views are a very useful resource in relational databases: they let you create logical representations of the data stored in…
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…
OracleHow to use hints in Oracle?
The super dictionary of Oracle hints When you work with Oracle, an important part of optimizing SQL query performance is…
OracleHow to create an Oracle 19c database in silent mode
Creating a single instance CDB database in silent mode After installing the database management system (DBMS), the next step is…
DatabasesThe CAP theorem
The CAP theorem (also known as Brewer’s theorem) is one of the key concepts in distributed systems. It was proposed…
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…
SQL ServerHow to enable the slow query log in SQL Server?
How to capture slow queries in SQL Server? If you come from the MySQL, PostgreSQL or even Oracle world, you…