LogMiner Eating Up the CPU
Hi everyone, Hope you’re doing good! A few days ago, a client complained about a slowness in their SAP DB environment running on Oracle. DB version is 19.24. I asked…
ORA-12514 when using TNS entry for SCAN_LISTENER
Hi everyone, Hope you all are doing great! It’s been a while since my last post. Well, today I’m going to share about an issue you all can get it…
How to Calculate Database Uptime Querying the Oracle Enterprise Manager Views
Hi everyone, Hope you’re doing good! Ensuring high availability of your Oracle databases is crucial for maintaining optimal performance and meeting Service Level Agreements (SLAs). Oracle Enterprise Manager (OEM) provides…
Why is the INSERT Statement Slow? Understanding ‘db file sequential read’ Waits
Some weeks ago, a client called complaining about a slowness during its load in a table. The scenario it was pretty simple: They are loading the table using the INSERT…
How to Efficiently Export a Large List of Tables with DataPump
Hi everyone, hope you’re doing good! I’m a member of a WhatsApp Group in Brazil for DBAs (not only Oracle), and one of the members asked about how to export…
STARTUP MOUNT failed with ORA-00210 ORA-00202 ORA-27086
Hi everyone, Hope you’re doing good. I’m working for a client which has Oracle DB for SAP applications. Those DB’s are not using RAC, yes, I know 🙂 SAP does…
Duplicate Database Hanging on “remote db file read”
Hi guys, Hope to you are good! I am working in a project to migrate some databases to Oracle RAC, and we decided to move to the RAC Databases using…
DiskGroup GRID: Understanding its contents
Hey all! In this blog post we’ll basically check what is the content for DiskGroup that was created by default when you install Oracle Grid Infrastructure in a Standalone Cluster…
