top of page

Success is about Imagination
Ignite Your Passion



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 24, 20101 min read
1 view
0 comments


Types of Data Visualization
http://www.visual-literacy.org/periodic_table/periodic_table.html
kyle Hailey
Apr 23, 20101 min read
2 views
0 comments
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
7 views
0 comments
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
0 views
0 comments


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
14 views
0 comments
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
3 views
0 comments


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
1 view
0 comments
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
5 views
0 comments


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
1 view
0 comments
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
2 views
0 comments
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
0 views
0 comments
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
8 views
0 comments
stopping long running queries (UNIX vs Windows)
Here is an interesting discussion on stopping long running queries by Tanel Poder: http://blog.tanelpoder.com/2010/02/17/how-to-cancel-a-...
kyle Hailey
Mar 5, 20101 min read
1 view
0 comments
Oracle Flash Cache on Linux with Exadata
cool stuff: Guy Harrison explains how to set up flash caching on Linux for Oracle without Exatata http://guyharrison.squarespace.com/blog...
kyle Hailey
Feb 11, 20101 min read
0 views
0 comments


SQL Plan visualization by Tanel Poder
Check this out – SQL Plan visualization by Tanel Poder: http://tech.e2sn.com/apps/planviz
kyle Hailey
Feb 11, 20101 min read
5 views
0 comments


Scalar Subqueries
Better formatted at http://tinyurl.com/yfrjbwx Query 2 The VST diagram looks like There are two interesting things about this diagram....
kyle Hailey
Feb 8, 20102 min read
2 views
0 comments


Oracle: SQL*Net Waits
article better formatted at http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-network-waits Introduction...
kyle Hailey
Feb 6, 20103 min read
7 views
0 comments


Tuning the Application, Database and Hardware
Tuning Example in 3 parts part 1 – “The Database is hanging!” AKA “the application has problems, good grief” I wonder if you can...
kyle Hailey
Feb 1, 20104 min read
1 view
0 comments
Hung database and can’t connect?
I can be exasperating when the database is slow or hanging and I can’t even connect to see what’s happening. In those cases, here is a...
kyle Hailey
Jan 31, 20101 min read
6 views
0 comments


Oracle Standard IO waits
from http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-io-waits Standard I/O select parameter1, parameter2, parameter3...
kyle Hailey
Jan 30, 20101 min read
26 views
0 comments
bottom of page