kyle Hailey
Outer Joins Graphically
Outer Joins If English and French both have a unique key on the “ordinal_id” then it’s basically one-to-one relationship We add an arrow...
top of page
Success is about Imagination
Ignite Your Passion
kyle Hailey
- Dec 24, 2009
- 5 min
Visual SQL Tuning
How would you go about tuning a query like this? SELECTa0.af1,a0.af2,a0.af3,c.af4,e.ef1,FROMa a0,(SELECT a1.af5, a1.af6, a1.af1,...
2 views0 comments
kyle Hailey
- Dec 17, 2009
- 1 min
Browser Size, Web Tools and the Fold line
When i was working on OEM, one of my many pet peaves was the size of browser pages, wasted space and data below the “fold line”. Here is...
0 views0 comments
kyle Hailey
- Dec 15, 2009
- 1 min
Oracle Wait Events: os-thread-startup
One goal I have over the next couple months is creating organized documentation on Oracle Wait events. One event, os-thread-startup, is...
0 views0 comments
kyle Hailey
- Dec 8, 2009
- 3 min
Changing performance strategies for modern operations
Three important factors to take into account in performance tuning of database operations: · Automation · Methodology · Collaboration...
0 views0 comments
kyle Hailey
- Dec 8, 2009
- 1 min
Taming the Performance Beast
Presented with Forrester’s Noel Yuhanna. Noel presented on the trends that are effecting performance, why it is critical to maintain...
0 views0 comments
kyle Hailey
- Dec 3, 2009
- 1 min
DB Optimizer 2.0 in the News!
Wow, I’m amazed and thrilled at all the press that DB Optimizer 2.0 is getting in the press. Check this out: SD Times Infoworld Codebeach...
0 views0 comments
kyle Hailey
- Nov 30, 2009
- 1 min
Advances in SQL Tuning Techniques at HOTSOS
http://www.hotsos.com/sym10/sym_speakers_hailey.html Advances in SQL Tuning Techniques In the past few years some novel SQL tuning...
1 view0 comments
kyle Hailey
- Nov 20, 2009
- 1 min
Graphics vs Text : Picture superiority effect
According to the picture superiority effect, concepts are much more likely to be remembered experientially if they are presented as...
5 views0 comments
kyle Hailey
- Nov 18, 2009
- 1 min
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...
2 views0 comments
kyle Hailey
- Nov 17, 2009
- 1 min
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...
3 views0 comments
kyle Hailey
- Nov 16, 2009
- 1 min
Future of Cloud Computing and Relational Databases
I was talking to someone from Amazon who indicated that Amazon is moving more and more processing away from Oracle into the middle tier...
1 view0 comments
kyle Hailey
- Nov 14, 2009
- 1 min
Clean Installs (Embarcadero’s All Access)
Ever have problems de-installing software on windows? Well Embarcadero has a new technology where there is no install for it’s windows...
0 views0 comments
kyle Hailey
- Nov 14, 2009
- 2 min
Oracle Users Group – NoCOUG Fri 13th
Had an enjoyable day at the NoCOUG held at Oracle Corp, my old stomping grounds. It was fun to see and catch up with Greg Rahn, John...
3 views0 comments
kyle Hailey
- Nov 12, 2009
- 1 min
Oracle Books online
Did you know Google books has some amazing Oracle resources on line? I’m giving a presentation tomorrow at the Northern California Users...
5 views0 comments
kyle Hailey
- Nov 12, 2009
- 1 min
Oracle 11g Baselines
this site http://kerryosborne.oracle-guy.com/2009/04/oracle-11g-sql-plan-management-sql-plan-baselines is the best source of information...
0 views0 comments
kyle Hailey
- Nov 12, 2009
- 1 min
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...
6 views0 comments
kyle Hailey
- Nov 9, 2009
- 1 min
Taking the black art out of SQL tuning
Nice article on DB Optimizer: Taking the black art out of SQL tuning by Martin Heller Embarcadero DB Optimizer 2 takes a methodical...
2 views0 comments
kyle Hailey
- Oct 22, 2009
- 1 min
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...
3 views0 comments
kyle Hailey
- Oct 22, 2009
- 2 min
Designers Need Creativity, Understanding, Solutions
Two interesting links 1. Overtime working at Flickr during startup days probably was ineffectual: http://www.fastcompany.com/blog/cliff-k...
1 view0 comments
bottom of page