top of page
Success is about Imagination
Ignite Your Passion
kyle Hailey
Jul 27, 20101 min read
An iPad for your thoughts?
Embarcadero s conducting a brief survey to learn more about database professionals what challenges do they face this year and day to day...
0 views0 comments
kyle Hailey
Jul 26, 20101 min read
Oracle 10053 SQL Trace Viewer
The infamous 10053 trace is probably the most extensive trace for understanding why the Oracle optimizer chose a query’s execution path...
51 views0 comments
kyle Hailey
Jul 25, 20101 min read
New VST graphics coming in DB Optimizer 2.5.1
I’m excited about the upcoming minor release of DB Optimizer in a few weeks, 2.5.1. Version 2.5.1 will have graphics for outer joins,...
0 views0 comments
kyle Hailey
Jul 23, 20102 min read
Speaking at the InSync10 event in Melbourne
I’ll be speaking at the InSync10 event in Melbourne about Database Performance Made Easy at the InSync10 event in Melbourne, Australia 16...
0 views0 comments
kyle Hailey
Jul 22, 20101 min read
"If I can’t picture it, I can’t understand it." – Albert Einstein
New book recommendation: Refactoring SQL Applications by Stephan FaroultI found the book easy to read, well thought out and covers...
10 views0 comments
kyle Hailey
Jul 6, 20101 min read
Oracle’s SQL Tuning Pack – part 3
How does the STA work in 11gR2 with the query from “Oracle’s SQL Tuning Pack – part 2” ? Here is the view on the Top Activity Page: The...
0 views0 comments
kyle Hailey
Jul 6, 20103 min read
Oracle’s SQL Tuning Pack, part 2
Above its the load produced by the same load. Its a query being run by 10 users 20 times with a sleep of random interval between 1-2...
1 view0 comments
kyle Hailey
Jul 1, 20102 min read
Oracle’s SQL Tuning Pack – how well does it work?
Have you used Oracle’s SQL Tuning Pack? What were your experiences like? At my last consulting gig 2 out 3 statements I “tuned” with the...
2 views0 comments
kyle Hailey
Jun 22, 20101 min read
DB Optimizer Demo Webinar June 22 @ 9am PST
We had almost 2000 people sign up for the webinar on SQL tuning with Jonathan Lewis and I. After the webinar many people had questions on...
0 views0 comments
kyle Hailey
Jun 16, 20101 min read
Data Structures: Knuth Got It Wrong
(Via Slashdot http://developers.slashdot.org/story/10/06/14/2225251/Knuth-Got-It-Wrong) Full article at http://queue.acm.org/detail.cfm?i...
0 views0 comments
kyle Hailey
Jun 14, 20101 min read
Jonathan Lewis / Kyle Hailey Webinar Replay
Thanks to everyone who joined for the webinar with Jonathan Lewis last Thursday. I’ve been getting a number of inquiries asking if the...
0 views0 comments
kyle Hailey
Jun 8, 20102 min read
Cursor_sharing : a picture is worth a 1000 words
Anyone who has been around Oracle performance over the years knows the grief that hard parsing SQL queries can cause on highly concurrent...
2 views0 comments
kyle Hailey
Jun 8, 20101 min read
More VST Notation
Just got DB Optimizer 2.5 out the door two weeks ago and now work is going fast on 2.5.1 slated for beginning of August. Already added...
1 view0 comments
kyle Hailey
May 30, 20103 min read
Identifying Execution Plan Problems
(original at http://sites.google.com/site/embtdbo/tuner/oracle-tcf-query-and-lios-per-row) Based on the idea by Wolfgang Breitling that...
3 views0 comments
kyle Hailey
May 30, 20101 min read
Oracle Video Demos
Just found this one http://www.oracle.com/technology/obe/demos/admin/demos.html video demos of Oracle features – pretty cool. For example...
2 views0 comments
kyle Hailey
May 30, 20101 min read
SQLPLUS -prelim
There is a way to connect to Oracle even when sessions are maxed out or there is a hang etc: I knew about this a while back but its just...
13 views0 comments
kyle Hailey
May 27, 20101 min read
Visual SQL Tuning Webinar with Jonathan Lewis June 10, 2010
Register for the live webinar on June 10th here: http://www.embarcadero.com/master-sql-tuners-oracle-lewis-hailey Tune in for the...
0 views0 comments
kyle Hailey
May 26, 20101 min read
Why graphics get a bad rap
Can you figure out what this chart is trying to say? I have a hard time of it: Here is the data laid out in a more compelling manner: I...
0 views0 comments
kyle Hailey
May 23, 20101 min read
Visual SQL Tuning Webinar with Jonathan Lewis June 10, 2010
UPDATE: register for webinar at http://www.embarcadero.com/master-sql-tuners-oracle-lewis-hailey Stay tuned for a live free webinar on...
0 views0 comments
kyle Hailey
May 5, 20101 min read
Jonathan Lewis and Visual SQL Tuning
Sometimes, it is a great idea to push away the keyboard when tackling the problems of an ill-performing, complex, query, and take up...
2 views0 comments
bottom of page