Category

Databases

Articles by Furushima specialists on Databases.

AI agent reading the production database via MCP: what I allow and what I blockAutomation

AI agent reading the production database via MCP: what I allow and what I block

Everyone wants to plug an AI agent into the database. Claude Desktop, Cursor, Copilot, the company’s internal chat. The request…

Matsuo Furushima
Protheus on PostgreSQL: should you replace SQL Server?PostgreSQL

Protheus 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…

Matsuo Furushima
Slow cost processing in Protheus, now what? What to do about it?Databases

Slow 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…

Matsuo Furushima
Oracle tablespace full: how to fix ORA-01652, ORA-01653 and ORA-30036Oracle

Oracle 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…

Matsuo Furushima
DBA support: in-house, outsourced or hybrid? A straightforward guide to decidingDatabases

DBA 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…

Matsuo Furushima
Protheus slow? Where to look for the cause: database, DBAccess and infrastructureDatabases

Protheus 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…

Carlos Furushima
SQL Server: PowerShell export and import with BCPSQL Server

SQL 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…

Acacio Lima Rocha
Oracle DBMS_SCHEDULER vs DBMS_JOB: a single package to manage, pause, and monitor jobsOracle

Oracle 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…

Carlos Furushima
Oracle storage structuresOracle

Oracle storage structures

How does Oracle store data? The Oracle Database storage structure is designed to be highly efficient and flexible, allowing large…

Weverton Amorim
Oracle Database startup/shutdown phasesOracle

Oracle Database startup/shutdown phases

Starting the Oracle database instance Before users can connect to a database instance, a database administrator must start the database…

Weverton Amorim