Oracle Insider

Stabilize Oracle 10G’s Bind Peeking Behaviour by Cutting Histograms

pythian.com16 comments

I wrote this post because I feel there is a great need for it. The number of people struggling with unstable query plans due to bind peeking in Oracle 10G is enormous, to say the least. More than that, solutions like…

Covered by:oracleinfogram.blogspot.com

EXPLAIN Cheatsheet

pythian.com4 comments

At the 2008 MySQL Conference and Expo, The Pythian Group gave away EXPLAIN cheatsheets. They were very nice, printed in full color and laminated to ensure you can spill your coffee* on it and it will survive.
For those…

Covered by:l-exp.com, blog.arabx.com.au

Bind Peeking, Ad Hoc Queries, Stable Performance. On 10G you can only pick any two.

pythian.com17 comments

I got to troubleshoot an amazing situation a few weeks ago. I think, we can all agree that assuming we are on a supported configuration of a production release of Oracle, it is essentially inconceivable that allowing a…

Pythian Group: The Ingres Vultures Descend

pythian.com6 comments

In a despicable business practice, I received a message from a PR Firm representing Ingres. Now, I even wrote about the controversy that seems to have swept the open source community; but even my writings were not…

Covered by:l-exp.com

When SHOW SLAVE STATUS lies

pythian.com5 comments

Over-the-Top Tales from the Trenches.
Motto: Bringing order to the chaos of every day DBA life.
So you have got your nice MySQL Master-Slave replication pair setup. Everything is sweet, then the master dies/restarts or…

Covered by:l-exp.com