PostgreSQLProtheus on PostgreSQL: should you replace SQL Server?
SQL Server 2016 is out of support and the Enterprise license weighs heavy. What TOTVS certifies on PostgreSQL, what it…
DatabasesSlow cost processing in Protheus, now what? What to do about it?
The average cost recalculation ran through the night, adding threads made it worse and a restart only holds for twenty…
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…
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…
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…
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…
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…
OCIHow to upload a SQL Server backup to an OCI bucket.
Backup safety is one of the main pillars of database administration. Keeping an external copy guarantees data recovery in case…
![[SCRIPT] – showplan.sql](https://furushima.com.br/wp-content/uploads/2025/01/SQL.png)
Oracle[SCRIPT] – showplan.sql
How do you know which part of the plan your query is spending the most time on?