Database Performance 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 … Apr 14, 2025 4 min read
Administration Clusterware 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 g… Jan 27, 2025 3 min read
Administration Database 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 … Jul 2, 2024 5 min read
Administration Database 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… Jun 25, 2024 10 min read
Administration Database 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 abo… Jun 11, 2024 3 min read
Administration Database 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, … Aug 17, 2023 6 min read
Administration 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 Database… Jul 3, 2019 3 min read
Architecture Arquitetura 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 … Jun 13, 2019 5 min read