Bryan's Oracle Blog

Well,   Here is the issue I've been dealing with.  The query cost doesn't stay consistent, and I was wondering if a profile woul...

I decided to write this blog entry because we ran into an issue over the weekend.  The process that normally runs fine, was running slow.. ...

Well I figured I document some of the magic numbers that the optimizer uses to help remember them, and help others. The back ground of this...

OK, Now I new Exadata coming in that has 3tb drives, and the first question asked is .. How much disk to I have to configure on it ?  Well ...

I've been starting to work with Extended statistics to help the optimizer find the best plan. This is a great feature that is outlined ...

I wanted to write up an Exadata tip that I learned. Background :  I wanted to do a simple "select count(1) from mytable".  myta...

While finishing up a few things, I ran across a query that wasn't playing nicely. It had 4 different plans over the course of the l...