NSMTIO
-
Note: this is the continuation of the previous post. The natural question arises: how can I set a trap for any specific SQL_ID which causes issues. Update: near the end of this part3 I have also included some immediate solutions to mitigate the problem supported by two other posts. The goal is to intercept an…
-
Note: this is continuation of the previous post. Now, let’s finally simulate my problem. To do that, I will force reading the table into the SGA.To remain fair, I won’t cache it entirely.Why am I considering it a “fair” approach?It’s hard to expect, after having executed your query that the entire large table, say 200GB…
-
This post contains 3 parts. Recently I witnessed an interesting case which added a headache to the application owners and the business.Namely, one of the important reports which used to run smoothly all of sudden stopped behaving.Talking numbers, something what people used to get within some seconds (up to 8) unexpectedly took close to 2…