top of page

Success is about Imagination
Ignite Your Passion



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


SQL Plan visualization by Tanel Poder
Check this out – SQL Plan visualization by Tanel Poder: http://tech.e2sn.com/apps/planviz
kyle Hailey
Feb 10, 20101 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....
kyle Hailey
Feb 8, 20102 min read


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


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
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


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


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...
kyle Hailey
Jan 29, 20102 min read


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...
kyle Hailey
Jan 25, 20101 min read
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...
kyle Hailey
Jan 24, 20103 min read


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...
kyle Hailey
Jan 18, 20101 min read


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...
kyle Hailey
Jan 18, 20101 min read


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...
kyle Hailey
Jan 14, 20106 min read
Hadoop
Ideas and quotes form original article by Guy Harrison on Hadoop Sets its Sights on Enterprise Computing Google’s algorithms have been...
kyle Hailey
Jan 13, 20101 min read


Data Visualization
http://www.perceptualedge.com/blog/ http://www.informationisbeautiful.net/ I’m always interested in new, innovative and powerful ways to...
kyle Hailey
Jan 12, 20101 min read


Oracle Wait: Buffer Busy Wait
Article originally on (with better formating) http://sites.google.com/site/embtdbo/wait-event-documentation/oracle-buffer-busy-wait...
kyle Hailey
Jan 12, 20109 min read
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...
kyle Hailey
Jan 11, 20101 min read


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...
kyle Hailey
Jan 9, 20103 min read


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...
kyle Hailey
Jan 8, 20109 min read


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...
kyle Hailey
Jan 6, 20101 min read
bottom of page