kyle Hailey
SQL Plan visualization by Tanel Poder
Check this out – SQL Plan visualization by Tanel Poder: http://tech.e2sn.com/apps/planviz
top of page
Success is about Imagination
Ignite Your Passion
kyle Hailey
- Feb 8, 2010
- 2 min
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, 2010
- 3 min
Oracle: SQL*Net Waits
article better formatted at http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-network-waits Introduction...
0 views0 comments
kyle Hailey
- Feb 1, 2010
- 4 min
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...
0 views0 comments
kyle Hailey
- Jan 31, 2010
- 1 min
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...
2 views0 comments
kyle Hailey
- Jan 30, 2010
- 1 min
Oracle Standard IO waits
from http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-io-waits Standard I/O select parameter1, parameter2, parameter3...
0 views0 comments
kyle Hailey
- Jan 29, 2010
- 2 min
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...
0 views0 comments
kyle Hailey
- Jan 25, 2010
- 1 min
The most common passwords!
Get the full story at http://www.imperva.com/docs/WP_Consumer_Password_Worst_Practices.pdf 32 Million passwords were analyzed at...
1 view0 comments
kyle Hailey
- Jan 25, 2010
- 3 min
ASH simulation Scripts (SASH and SASHMON)
(see http://sites.google.com/site/embtdbo/wait-event-documentation/sash-1) I’ve gotten a few questions on SASH and SASHMON recently, so I...
3 views0 comments
kyle Hailey
- Jan 18, 2010
- 1 min
BAARF – Battle against any raid 5
BAARF – Battle Against any Raid Five http://www.miracleas.com/BAARF/BAARF2.html In the chart below, 1 represents good and 5 represents...
2 views0 comments
kyle Hailey
- Jan 18, 2010
- 1 min
IO operations per second
Vendors say that read cache will take care of IO Operations per sec, but if you have a sustained throughput it will only sustain for so...
0 views0 comments
kyle Hailey
- Jan 14, 2010
- 6 min
Oracle Waits – latch : cache buffer chains
(article best formated at link:http://tinyurl.com/ybyjazq) Waits on the cache buffer chains latch, ie the wait event “latch: cache...
1 view0 comments
kyle Hailey
- Jan 13, 2010
- 1 min
Hadoop
Ideas and quotes form original article by Guy Harrison on Hadoop Sets its Sights on Enterprise Computing Google’s algorithms have been...
0 views0 comments
kyle Hailey
- Jan 12, 2010
- 1 min
Data Visualization
http://www.perceptualedge.com/blog/ http://www.informationisbeautiful.net/ I’m always interested in new, innovative and powerful ways to...
0 views0 comments
kyle Hailey
- Jan 12, 2010
- 9 min
Oracle Wait: Buffer Busy Wait
Article originally on (with better formating) http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-buffer-busy-wait...
2 views0 comments
kyle Hailey
- Jan 11, 2010
- 1 min
Improved Oracle searches on Google
Often when searching for information on Oracle via Google, the first links that show up are sites that lack any depth or rigor and I...
0 views0 comments
kyle Hailey
- Jan 9, 2010
- 3 min
Machine, application or database ?! Where’s the bottleneck?
When a bottleneck happens how can you know whether It’s an application problem Machine is undersized SQL requires optimization Database...
5 views0 comments
kyle Hailey
- Jan 8, 2010
- 9 min
A Sampling We Will Go
Oracle wait events took years to become widely known for their power in performance tuning. With this article you’ll be able to beat the...
0 views0 comments
kyle Hailey
- Jan 6, 2010
- 1 min
KISS – Keep It Simple Stupid
I like this guys attitude: Information architecture should be focused on making it easier to understand and navigate content — as quickly...
0 views0 comments
kyle Hailey
- Jan 4, 2010
- 4 min
Visually Identifying SQL Optimizer Weaknesses
Did you know that Oracle only joins one table at a time? As Dan Tow puts in his book “SQL Tuning“ [Oracle] simply takes what it’s got at...
4 views0 comments
bottom of page