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 them to run eDB360. With the eDB360 output in hand, I did notice something wrong:…
How to Create a SQL Patch for a Query from the AWR views
Hey everyone, Hope you’re doing good! In most applications, application code is static and cannot be modified by users. If there is a performance issue with application SQL, one potential solution is to modify it adding hints to force the desired access path. Sometimes, the…
Disclaimer
My postings reflect my own views and do not necessarily represent the views of my employer, Accenture.