Bryan's Oracle Blog
Oracle Database Architecture blog sharing my experiences as an oracle Architect.
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 ...
Sunday, July 15, 2012
Exadata tips
›
I wanted to write up an Exadata tip that I learned. Background : I wanted to do a simple "select count(1) from mytable". myta...
Friday, July 6, 2012
What happened to my sql (sql_id) ?
›
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...
‹
›
Home
View web version
