How to Reclaim Space from LOBs: A Practical Case Study
Hi everyone, hope you all are doing well! At our company, we have an internal distribution list where we discuss technical issues, challenges, etc. A question came in this week:…
Introducing: The AutoUpgrade-Composer Tool [STABLE]
Hi everyone, Hope you’re doing well. On May 13th, I released the BETA version of the AutoUpgrade-Composer Tool. You can read the announcement here: Introducing: The AutoUpgrade-Composer Tool If you’ve…
AutoUpgrade-Composer: Downloading and Applying the N-2 RU with Deploy Mode
Hi everyone, hope you’re doing good. This is the second post in a series of blog posts exploring the potential of AutoUpgrade-Composer, as we may have dozens of scenarios. In…
AutoUpgrade-Composer: Creating the Configuration to Patch a Database (Deploy Mode) not Downloading the Patches
Hi everyone, hope you’re doing good. A few days ago, I released the BETA version of my new tool: AutoUpgrade-Composer. You can read about the release here: Introducing: The AutoUpgrade-Composer…
Introducing: The AutoUpgrade-Composer Tool [BETA]
Hi everyone, Hope you’re doing well. Today is a special day for me. I’m really happy to announce the release of the BETA version of my tool: AutoUpgrade-Composer Context I’ve…
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…
