Tuesday, November 12, 2013

Oracle 12c PL/SQL improvements.

›
Last week I was giving a presentation for the UNYOUG (Upstate NY Oracle users Group) and I talked about the new features in 12c (along wit...
1 comment:
Wednesday, January 9, 2013

Performance and Indexes with oracle

›
It's been a while since I've written a post, but twice this week, the same issue came up.. The story goes like this.. "I hav...
1 comment:
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...