Poor Performance related to ADS (Part 1)

We experienced an issue of spinning cpu which required us to apply a one of patch,
at the same time we applied the latest PSU patch April 2016.
3 days later when a batch was running we got performance problems,
the batch was taking much longer than before.

Continue reading

Advertisements

Cursors not shared due to ROLL_INVALID_MISMATCH

I frequently check my customers databases, during one of these controls I found that we had many versions of the same sqls with reason ROLL_INVALID_MISMATCH. I do not experiencing an issue around high version count. Hard parse is not an issue and shared_pool is not using a lot of memory. I just want to understand whats behind the figures. This is what I found.

Continue reading