Monday, November 12, 2012

Big Data and Privacy

›
I am writing an editorial (which is unusual for me). This was caused by a conversation I had with my Dad about how the world is changing wi...
1 comment:
Saturday, November 3, 2012

ODI Monitoring scripts

›
I have included some usefule ODI monitoring scripts (if you want the abridged version of this blog post). I haven't been blogging in ...
4 comments:
Friday, October 5, 2012

Anayzing query Cost example

›
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...
1 comment:
Wednesday, September 5, 2012

"enq: CR - block range reuse ckpt" and the recycle bin

›
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.. ...
2 comments:
Tuesday, September 4, 2012

Recognize the magic optimizer numbers

›
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...
Saturday, September 1, 2012

Exadata sizing updated for 3tb drives 1/2 rack SATA

›
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 ...
Tuesday, July 31, 2012

What extended stats do I have on my database?

›
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 ...