top of page

Success is about Imagination
Ignite Your Passion



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...
kyle Hailey
Jun 8, 20101 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...
kyle Hailey
May 30, 20103 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...
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...
kyle Hailey
May 30, 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...
kyle Hailey
May 27, 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...
kyle Hailey
May 26, 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...
kyle Hailey
May 23, 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...
kyle Hailey
May 5, 20101 min read
Oaktable Website
Thanks to the valient work of James Morle there is a awesome new website aggregating the work and postings of the members of the Oaktable...
kyle Hailey
Apr 23, 20101 min read


Types of Data Visualization
http://www.visual-literacy.org/periodic_table/periodic_table.html
kyle Hailey
Apr 23, 20101 min read
calculating the SQL_ID hash from the SQL_TEXT
This really cool: http://www.slaviks-blog.com/2010/03/30/oracle-sql_id-and-hash-value/ he explains a how to calculate the sql_id from the...
kyle Hailey
Mar 31, 20101 min read
VST – complete for DB Optimizer 2.5 !
blue numbers are the percent of the table returned after the predicate filters have been applied red numbers are the two table join sizes...
kyle Hailey
Mar 26, 20101 min read


VST – Visual SQL Tuning , the next generation
If you saw my presentation at HOTSOS 2010 or attended one of my recent Oracle 10g Performance Tuning course, you know I’m excited about...
kyle Hailey
Mar 19, 20102 min read
managing statistics on partitions
The best methods for managing statistics in general on Oracle is an area that has yet to well ironed out but when it comes to partitions...
kyle Hailey
Mar 17, 20101 min read


Trending with Statspack
Anjo use to do statspack analysis at oraperf.com which has been out of order every time I’ve looked over the past few years. Tim Gorman...
kyle Hailey
Mar 17, 20101 min read
Monitoring SQL run on MySQL
Nice example of using Wireshark to monitor what’s getting run on MySQL. http://feedblog.org/2008/07/29/debugging-mysql-applications-with-...
kyle Hailey
Mar 16, 20101 min read


Bug or Feature
I love this little cartoon comes from http://www.oraclealchemist.com/oracle/this-bug-brought-to-you-by-the-letter-u/ which is a funny...
kyle Hailey
Mar 16, 20101 min read
What Bind Variable values were used in my Query
Check out this query by Kerry Osborne via Oracle-L (archives at Oracle-l Archives) for getting the peeked bind variable values from...
kyle Hailey
Mar 16, 20102 min read
who opened that DB Link
very nice analysis of tracking down who has a dblink open on another database http://jkstill.blogspot.com/2010/03/whos-using-database-lin...
kyle Hailey
Mar 5, 20101 min read
ORASRP: 10046 trace file formating
In case you have seen this free tool: http://www.oracledba.ru/orasrp/ It’s pretty cool. Takes 10046 trace files and analyzes and formats...
kyle Hailey
Mar 5, 20101 min read
bottom of page