kyle Hailey
Types of Data Visualization
http://www.visual-literacy.org/periodic_table/periodic_table.html
top of page
Success is about Imagination
Ignite Your Passion
kyle Hailey
Mar 31, 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...
7 views0 comments
kyle Hailey
Mar 26, 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...
0 views0 comments
kyle Hailey
Mar 19, 20102 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...
14 views0 comments
kyle Hailey
Mar 17, 20101 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...
3 views0 comments
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...
1 view0 comments
kyle Hailey
Mar 16, 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-...
3 views0 comments
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...
1 view0 comments
kyle Hailey
Mar 16, 20102 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...
2 views0 comments
kyle Hailey
Mar 5, 20101 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...
0 views0 comments
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...
4 views0 comments
kyle Hailey
Mar 5, 20101 min read
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-...
0 views0 comments
kyle Hailey
Feb 11, 20101 min read
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...
0 views0 comments
kyle Hailey
Feb 10, 20101 min read
SQL Plan visualization by Tanel Poder
Check this out – SQL Plan visualization by Tanel Poder: http://tech.e2sn.com/apps/planviz
5 views0 comments
kyle Hailey
Feb 8, 20102 min read
Scalar Subqueries
Better formatted at http://tinyurl.com/yfrjbwx Query 2 The VST diagram looks like There are two interesting things about this diagram....
0 views0 comments
kyle Hailey
Feb 6, 20103 min read
Oracle: SQL*Net Waits
article better formatted at http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-network-waits Introduction...
3 views0 comments
kyle Hailey
Feb 1, 20104 min read
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...
1 view0 comments
kyle Hailey
Jan 31, 20101 min read
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...
3 views0 comments
kyle Hailey
Jan 30, 20101 min read
Oracle Standard IO waits
from http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-io-waits Standard I/O select parameter1, parameter2, parameter3...
12 views0 comments
kyle Hailey
Jan 29, 20102 min read
Oracle Redo Log Waits
In an ongoing effort to document the main Oracle wait events, here is my current effort at documenting Oracle’s redo log related wait...
12 views0 comments
bottom of page