Your database history is precious. Keeping it is crucial. Keep it as if you keep a valuable treasure.
And why is that? because it holds the normal and the abnormal behaviour of your database, and both or them are equally important.
It will save you, over and over again. That’s a guarantee. (more…)
The following simple update was running every evening, endlessly, on a production Exadata machine, Oracle version 11.2.0.3 (well, not truly endlessly, but for about an 30-60 minutes, which is considered to be quite endless in my standards…). (more…)
Exadata or not, sometimes Oracle is still Oracle, optimizer is still optimizer, and math is still math.
Here is the story: Instance is Oracle 11.2.0.3, running on an Exadata machine (X2-2 half Rack).
User is complaining query is taking too long to finish (about 5 minutes).