FeaturedOracleOracle tablespace full: how to fix ORA-01652, ORA-01653 and ORA-30036
How to tell which space error you got, diagnose it in three queries, unblock the operation with no downtime and find the real cause of the growth.
AutomationAutoDump: automated Oracle dump import, from the Azure download to a ready PDB
Every implementation team knows the scene: a new client’s dump arrives and a ticket is born for the DBA. Create…
ProtheusProtheus migration with zero downtime: how to upgrade an 11 TB environment without stopping the operation
The architecture that upgraded a Protheus system with an 11 TB Oracle database without stopping the operation: CDC replication, two…
DatabasesDBA support: in-house, outsourced or hybrid? A straightforward guide to deciding
In-house, outsourced or hybrid DBA: real costs, 24×7 coverage, what to demand in the contract and how to compare the…
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…
ProtheusProtheus managed support: what it is, what it covers and when to hire it
Protheus managed support (AMS) in practice: what a good operation covers, from release to database, the warning signs and how…
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 data block recovery
Recovering corrupted data blocks in Oracle Database is an essential technique to preserve data integrity without having to restore the…
SQL ServerSQL Server: PowerShell export and import with BCP
Hey hey folks, how about some SQL Server today? 👀 Like every good DBA, we often run into the need…
MySQLTransportable Tablespace in MySQL: the definitive guide
Hey folks, everything cool, everything smooth, all good? I hope so. Today, one more article about that darn dolphin database.…