kyle Hailey
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...
top of page
Success is about Imagination
Ignite Your Passion
kyle Hailey
Nov 17, 20091 min read
Explain Plan vs Real Plan on Oracle
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...
14 views0 comments
kyle Hailey
Nov 12, 20091 min read
Real Time SQL Monitoring
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...
23 views0 comments
kyle Hailey
Oct 22, 20091 min read
Oracle DBA Views !
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...
16 views0 comments
kyle Hailey
Sep 4, 20091 min read
Outlines from DBMS_XPLAN
dbms_xplan.display_cursor will output the hints for a plan. These hints can then be taken and used in an outline for plan stability:...
5 views0 comments
kyle Hailey
Sep 4, 20091 min read
dbms_xplan.display_cursor – what are all those arguments?
Nice table on http://www.psoug.org/reference/dbms_xplan.html and some more discussion on http://jonathanlewis.wordpress.com/2008/03/06/db...
14 views0 comments
kyle Hailey
Sep 4, 20091 min read
Diff’ing Explain Plans
Diff’ing explain plans is difficult and tedious.>Here is a new package function from Oracle for diff’ing explain plans...
8 views0 comments
kyle Hailey
Sep 3, 20091 min read
Explain Plans
Explain Plans can be had via Explain Plan (version ? ancient) Trace Files (starting 7.3) Autotrace (starting 8.1.7) V$SQL_PLAN (starting...
2 views0 comments
kyle Hailey
Sep 3, 20091 min read
Alberto Dell’Era’s XPLAN
Check out Alberto Dell’Era’s SQL query analyzer – lots of good info like this compact table of indexes availble on the query:...
18 views0 comments
kyle Hailey
Jun 26, 20091 min read
SQL Joins
Growing up on Ansi 89 and working at Oracle for 10 years, some of the the cleaner SQL join notation seems new to me. Here is a great...
18 views0 comments
bottom of page