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…
Finding the Needle in the Haystack: Troubleshooting Performance Issues with ASH and dashtop.sql
Hi all, I hope you’re doing good. After a client migrated their main database to RAC (they just did the switchover from Single Instance to RAC using Data Guard), they…
Effective Management of $ORACLE_HOME/.patch_storage: Cleanup and Archive Strategies
Hi all, Hope you’re doing good! I had a call with one of our clients, long story short, they would like to cleanup some space under $ORACLE_HOME/.patch_storage directory. There are…
Automating Bulk Data Loads into Oracle Database with Shell Script and SQL*Loader
Hey everyone, Hope you’re doing good! Recently, a client approached me with an urgent issue: they needed to load 456 files into an Oracle Database table to resolve an integration…
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…
Disk failed even using Multipath. How? Why?
Hi everyone, hope you’re doing good. In my last post I explained some basic concepts about Multipath and the importance to use it. You can read more here: Device Mapper…
