OracleOracle 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…
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…
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…
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…
OracleHow to install Oracle Database 19c on Oracle Linux
Oracle Database 19c on Oracle Linux 7.9 in silent mode To install Oracle Database 19c, the operating system must be…
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…