top of page

Success is about Imagination
Ignite Your Passion





Database Thin Cloning: Allocate on Write (ZFS)
Allocate on Write Thin Cloning Three challenges specifically stand out when considering Copy on Write filesystem snapshots described in...
kyle Hailey
May 31, 201410 min read


Database Thin Cloning: WAFL (Netapp)
Write Anywhere File Layout (WAFL) With EMC, thin cloning can only be achieved by using backup technology; in essence, the process has to...
kyle Hailey
May 30, 20143 min read


Database Thin Cloning: Copy on Write (EMC)
Copy on Write Copy on write is a storage or filesystem mechanism that allows storage or filesystems to create snapshots at specific...
kyle Hailey
May 29, 201411 min read


Database Thin Cloning : clonedb (Oracle)
A production database is full of data that makes sense for its purpose, whether the database is 10GB or 10TB. Now if you take that...
kyle Hailey
May 28, 20146 min read


Which to tune ? Application, Database or Hardware ?
I. “The Database is hanging!” AKA “the application has problems, good grief” I wonder if you can imagine, or have had the experience of...
kyle Hailey
May 27, 20145 min read
Data masking made easy with agile data
How long does it take you to make a copy of production, find the sensitive data, mask that data and then make multiple copies for...
kyle Hailey
May 23, 20141 min read


Graphing Oracle v$sysstat
One thing I’ve failed to clearly document is that my tool ASHMON not only graphs ASH data but graphs v$sysstat as well. To access...
kyle Hailey
May 23, 20142 min read


Virtual Cloning Oracle EBS stack in minutes
How does one clone in a few minutes and for almost no storage the entire EBS stack including the database, EBS application stack and...
kyle Hailey
May 22, 20141 min read


5 Databases issues that are costing you time and money
Companies rely on applications to supply the information that business uses to make decisions that generate revenue. Companies are...
kyle Hailey
May 21, 20149 min read


How to get dreadful database performance
I love this video on “getting dreadful database performance” by Stephane Faroult. The video is hilarious and informative:...
kyle Hailey
May 21, 20142 min read


SQL*Plus Procedures and Password Encryption
One small but bothersome issue I’ve had for 20 years is how to drive a program like SQL*Plus with a shell script to make it...
kyle Hailey
May 20, 20145 min read


Sampling Performance Data on Oracle
Oracle wait events took years to become widely known for their power in performance tuning. Similarly it has taken years for most DBAs to...
kyle Hailey
May 19, 20149 min read


I want to be a simplifier – thanks Steve Jobs
Any intelligent fool can make things bigger and more complex. It takes a touch of genius – and a lot of courage – to move in the opposite...
kyle Hailey
May 16, 20142 min read


Why did Google succeed? Yahoo shuts altavista down
Yahoo shut Altavista down a couple of years ago. Why did Google succeed when Altavista had index the web before Google ever started? Dan...
kyle Hailey
May 15, 20142 min read


Date conversions
Dates are a surprising pain for correlating data an at the same time being understandable to the human reader. For a generic form we can...
kyle Hailey
May 14, 20142 min read


I/O wait histograms in Oracle
DBA_HIST_EVENT_HISTOGRAM has a history of I/O latency histograms. DBA_HIST_EVENT_HISTOGRAM is only on 11g, so for 10g, it requires...
kyle Hailey
May 13, 20143 min read


Version control a multi-terrabyte database?! Yes !
Can you version control database? How do you manage databases in application development? For all the advances in application...
kyle Hailey
May 12, 20143 min read


NFS max “rsize” on Solaris – gotcha
When mounting NFS file systems there is an option to set the max rsize requested. For example: mount -o rsize=1048576,wsize=1048576,proto...
kyle Hailey
May 9, 20141 min read


Query slower on exact clone
A customer was working with a clone copy of their production database for reports, but the cloned database reports were running slower...
kyle Hailey
May 8, 20144 min read


Full table scan runs way slower today!
Every so often a DSS query that usually takes 10 minutes ends up taking over an hour. (or one that takes an hour never seems to finish)...
kyle Hailey
May 7, 20142 min read
bottom of page