Success is about Imagination

Ignite Your Passion

Oracle’s Cardinality Hint, Profiles, Outlines and SQL Baselines

This is more of a bookmark for a future blog post on using the Cardinality hint. This post by Greg Rahn give some example and I posted in...

kyle Hailey

Nov 18, 20091 min read

A good part of my presentation Friday at NoCOUG was on explain plan command being an estimate of the actual execution plan. Now on the...

kyle Hailey

Nov 17, 20091 min read

here is a feature that I’m excited about: Real Time SQL Monitoring http://askdba.org/weblog/2009/09/11gr2-monitoring-real-time-sql-plan-e...

kyle Hailey

Nov 12, 20091 min read

Ever wonder why some of those DBA_ views take so long to execute? here is the view expansion of a query from SYS.DBA_ALL_TABLES joined...

kyle Hailey

Oct 22, 20091 min read