Bryan's Oracle Blog

Oracle Database Architecture blog sharing my experiences as an oracle Architect. These opinions and recommendations are my own.

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...
Friday, June 29, 2012

AWR compare report

›
I came across this while doing some dbreplays, and found it very useful. First, lets say you have a RAC cluster,  and you want to do so...
Sunday, June 24, 2012

Taking a career change

›
Well, I have decided to make a change and take a job with oracle.  I am very excited about this move, and I look forward to being more invo...
2 comments:
Wednesday, May 23, 2012

Problem debugging for DBFS

›
In trying to find out the cause of a DBFS issue, I learned what is expected (or helpful) when working with Support on DBFS issues. 1)  L...
Friday, May 18, 2012

Where is my space on DBFS

›
I just ran into an issue on DBFS where I ran out of space. First here is the df -k Filesystem 1K-blocks Used Avai...
1 comment:
‹
›
Home
View web version

About Me

My photo
Bryan Grenn
View my complete profile
Powered by Blogger.