I dedicate this post to Pieter Van Puymbroeck, who left us way too early. I actually sent him details about this issue one day before I got the news of
Category: Troubleshooting
Checking SQL Progress in OracleChecking SQL Progress in Oracle
Checking an SQL statement progress is never easy. There are so many parameters that affect your execution time and estimates are never correct. So in this post I’ll mention a
ORA-30481 After Upgrading to 19cORA-30481 After Upgrading to 19c
Lately I’m in the process of upgrading a few clients to 18c and 19c, so I expected to hit a few issues. In this post I’ll discuss a specific issue
High CPU With Queries Without Bind VariablesHigh CPU With Queries Without Bind Variables
Performance problems can be tricky, and everyone has a different method to approach them depending on the exact issue. In this case I’d like to cover a specific case of
Many Usm Processes in Oracle RestartMany Usm Processes in Oracle Restart
This is something I’ve seen for a while now. It all started when I upgraded an Oracle Restart environment from 11.2.0.4 to 18.7. Suddenly our monitoring system alerted that the
Oracle Real Memory UsageOracle Real Memory Usage
I’ve been struggling with that for a while now, so in this post I’d like to explain what I’ve found so far and what I’m missing. If you can help
Did You Know #35 – New Child Cursor Creation ReasonDid You Know #35 – New Child Cursor Creation Reason
In many cases we see a new child cursor for existing SQL. You can see the children and their information in V$SQL (where CHILD_NUMBER identifies the child). To see the
Debugging ORA-1775Debugging ORA-1775
ORA-1775 “looping chain of synonyms” can be found online quite easily. But every time they talk about a real loop of synonyms (like syn1 -> syn2 -> syn3 -> syn1)
Oracle Data Guard Explained – Step By StepOracle Data Guard Explained – Step By Step
Oracle Data Guard consists of many components. In this post I’ll explain about an environment that helped me understand how all the components work. This is a 12.1.0.2 (with APR
ORA-7445 in 18cORA-7445 in 18c
I upgraded a test database not too long ago to 18.6 (to do proper testing before we start upgrading productions) and got a feedback from dev that one of the