Bryan's Oracle Blog

Expert insights on Oracle Database, Zero Data Loss Recovery Appliance (ZDLRA), backup and recovery strategies, database security, and enterprise database solutions by Bryan Grenn.

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

View web version

About Me

Bryan Grenn

View my complete profile

Powered by Blogger.