top of page

Success is about Imagination
Ignite Your Passion



Installing Oracle on RHEL
UPDATE: thanks to Alex Gorbachev for pointing out that Oracle has a public yum for OEL which is compatible with REHEL and Oracle has...
kyle Hailey
Jan 13, 20121 min read


10053 Trace file viewer
Back in http://dboptimizer.com/2010/07/26/oracle-10053-sql-trace-viewer/ I mentioned an Oracle 10053 trace file viewer. Well now there is...
kyle Hailey
Jan 9, 20121 min read
ASH Exploding Across Versions
I sometimes forget which versions of ASH have which fields, so here is a bit of a graphic and textual cheat sheet. (see...
kyle Hailey
Dec 16, 20111 min read
Getting Started with Dtrace
Structure of a dtrace script #!/usr/sbin/dtrace -s something_to_trace / filters / { actions } Something_else_to_trace /...
kyle Hailey
Dec 13, 20116 min read
Right Deep, Left Deep and Bushy Joins
At UKOUG someone asked me if DB Optimizer’s VST diagrams could deal with left deep verses right deep execution plans. What is right deep...
kyle Hailey
Dec 9, 20113 min read


Confio Ignite
People have been asking me recently, “what is the best enterprise database monitoring software?” Of course for Oracle there is OEM but...
kyle Hailey
Dec 1, 20115 min read
S-ASH 2.3 available
see: http://oracleprof.blogspot.com/2011/11/new-release-of-s-ash-v23.html “New features: – new easier installation process – new...
kyle Hailey
Nov 27, 20111 min read
Solaris IPS documentation
Oracle’s Image Packaging Service (IPS) is documented here: http://www.oracle.com/technetwork/server-storage/solaris11/technologies/ips-32...
kyle Hailey
Nov 21, 20112 min read
Procedural SQL*Plus 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
Nov 17, 20115 min read
Why does the same job run slower on an 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
Nov 14, 20114 min read


Why OEM drives me crazy sometimes
OEM just seems to have too many brittle esoteric configuration files and process dependencies. Ideally I just want to connect with...
kyle Hailey
Nov 10, 20111 min read


EMlight
I’ve been meaning to blog about EMlight (http://obzora.com) for a while. I first tried it about 6 months ago, and was impressed. ...
kyle Hailey
Nov 10, 20112 min read
Importing AWR repositories from cloned databases
I sometimes want to import AWR repositories from cloned databases to compare performance differences between the databases which should...
kyle Hailey
Nov 8, 20111 min read


W-ASH : Web Enabled ASH
I’m excited about the ease of creating rich user applications that are web enabled given the state of technology now. JavaScript and...
kyle Hailey
Oct 31, 20112 min read


NoCOUG’s 100th Conference Nov 9th!
Download the 100th issue of the NoCOUG Journal at http://bit.ly/rC2gRA. Can you believe it? 100 conferences! The Northern California...
kyle Hailey
Oct 25, 20111 min read
Tuning Blog Entries
Organizing some of my past blog entries on Oracle database performance tuning and analysis. I’ll add more notes as well as a separate...
kyle Hailey
Oct 20, 20111 min read


OEM 12c , cloud control
Was emailing with my esteemed college John Beresniewicz at Oracle in the OEM group. John and I worked together on OEM 10g and thank...
kyle Hailey
Oct 14, 20111 min read
NoCOUG: Performance Training with Gaja Vaidyanatha Nov 15,16
There are only three days left (Sept 30) to get the early bird rate for the Oracle Performance Management Seminar by Gaja Krishna...
kyle Hailey
Sep 28, 20111 min read
I/O Benchmarking tools
This blog post will be a place to park ideas and experiences with I/O benchmark tools and will be updated on an ongoing basis. Please...
kyle Hailey
Sep 28, 20113 min read
Orion I/O calibration tool bug
All of my I/O testing and benchmarking has been geared toward Oracle, so the natural choice would for benchmarking I/O would be orion,...
kyle Hailey
Sep 27, 20113 min read
bottom of page