Administration Database 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_… Jul 16, 2024 17 min read
Administration Database 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 Da… Jul 9, 2024 8 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
Enterprise Manager Ansible Playbook to Show the Current RU for OEM Agents Hi everyone, Hope you're doing good! In my last blog post I explained how to update Oracle Enterprise Manager and its OEM Agents from RU 13.… Apr 8, 2024 6 min read
Enterprise Manager How to Update Oracle Enterprise Manager from RU 13.5.0.16 to RU 13.5.0.20 Hi everyone, Hope you're doing good. A client contacted us asking to update their Oracle Enterprise Manager and its agents from 13.5.0.16 to… Apr 1, 2024 14 min read
Administration Clusterware CLSRSC-180: An error occurred while executing the command ‘/bin/rpm -qf /sbin/init’ during postpatch Hello everyone, Hope you're doing good. Over the last weeks I published two blog posts regarding upgrade DB Server Operating System from RHE… Mar 27, 2024 4 min read
