However, the number of child cursors built back up rather quickly …
The errors in the alert log were far more frequent than the database hangs, so clearly there was another factor involved …
I therefore felt a bit sheepish that I had been investigating what was apparently not the real problem …
What was happening was that when parallelism is used the optimiser can decide to use a high level of dynamic sampling.
There were all kinds of errors in the log, but the one of most concern was …
I was just about to go into a meeting with two chaps from MongoDB when I was asked by a colleague to help with a…
During the implementation of a change I noticed that there was an alert in Ops Manager for a Development MongoS host that was down. After…
This is more by way of amusement than an actual investigation. I had been asked to monitor a test of a new piece of application…
This is a rather quick investigation, but it shows some interesting Oracle behaviour. I had written a PL/SQL package that manages range partitioned tables: adding…
Whilst I was away on holiday, the primary query in a particular batch process changed plan. An appropriate baseline was create for it but this…