top of page
Success is about Imagination
Ignite Your Passion
kyle Hailey
Aug 5, 20113 min read
Interview with Kyle Hailey in oracle-class.com
Interview appears in www.oracle-class.com: 1- Why did you choose to specialize in Oracle databases? I wanted to live in San Francisco...
4 views0 comments
kyle Hailey
Aug 4, 20112 min read
Trace3 customer experience with Delphix
People often ask me what I work on now after having been at Oracle, Embarcardero and Quest. I’m now at a company called Delphix where I...
2 views0 comments
kyle Hailey
Jul 27, 20112 min read
Free Webinar with Cary Millsap, Kerry Osborne and Karen Morton
Thursday, July 28 11:00am PDT : Register Here Last post I talked about the Method R performance tuning tools for Oracle. The creation...
1 view0 comments
kyle Hailey
Jul 25, 20112 min read
Method-R Tools
It’s rare to find professional level tools that are written by the people who use them. Most professional tools are written by teams of...
2 views0 comments
kyle Hailey
Jul 23, 20112 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...
0 views0 comments
kyle Hailey
Jul 21, 20115 min read
Oracle CPU time
There are 3 kinds of CPU in the Oracle stats. Oracle CPU used System CPU used Oracle demand for CPU Starting in 10g Oracle records both...
331 views0 comments
kyle Hailey
Jul 20, 20111 min read
Oracle time units in V$ views
Oracle has a crazy mix of units of time in various v$ views seconds centi-seconds milliseconds microseconds Some are straight forward...
1 view0 comments
kyle Hailey
Jul 20, 20115 min read
Wait Event and Wait Class Metrics vs v$system_event
This post is a followup to the first metric post on statistics: http://dboptimizer.com/2011/07/07/mining-awr-statistics-metrics-verses-st...
218 views0 comments
kyle Hailey
Jul 19, 20111 min read
NFS throughput testing trick (solaris)
When testing the read and write speed to an NFS mounted file system it’s often unclear if the bottleneck is the speed of the network...
1 view0 comments
kyle Hailey
Jul 18, 20111 min read
Listener won’t register database
I must admit, I’m a sqlnet hack. I never really sat down to figure it out. If I have problems getting a database to register with a...
0 views0 comments
kyle Hailey
Jul 15, 20111 min read
Time : Orders of Magnitude
Just and interesting image on the relative orders of magnitude of different latencies.
2 views0 comments
kyle Hailey
Jul 14, 20112 min read
LGWR redo write times (log file parallel write)
General ***rule of thumb*** I’ve heard and buy into is that decent log file syncs times should be 3ms or under. Well “log file sync”...
1 view0 comments
kyle Hailey
Jul 13, 20111 min read
Explain plan nodes sized by time
Thought I had blogged about this before but couldn’t find the reference. Tanel Poder put together a nifty tool that takes an explain plan...
2 views0 comments
kyle Hailey
Jul 9, 20112 min read
Ratio of Redo bytes to Datablocks writes
Someone recently asked me what’s the ratio of redo generation to datablock writes, and of course I answered it depends, but like so many...
2 views0 comments
kyle Hailey
Jul 8, 20114 min read
Woohoo: VST takes the next step
The new release of DB Optimizer , version 3.0, from Embarcadero has awesome new feature : explain plan overlay onto VST diagrams! Let’s...
54 views0 comments
kyle Hailey
Jul 7, 20113 min read
Mining AWR: Statistics Metrics verses Statistics
Update: second posting on wait event metrics at: http://dboptimizer.com/2011/07/20/wait-event-and-wait-class-metrics-vs-vsystem_event/ In...
1 view0 comments
kyle Hailey
Jun 21, 20113 min read
AWR mining – I/O wait histograms
UPDATE: July 12, 2011 I just noticed (!) that the DBA_HIST_EVENT_HISTOGRAM is only on 11g, so for 10g, it requires collecting the...
1 view0 comments
kyle Hailey
Jun 20, 20112 min read
AWR mining
Update: nice query from Jonathan Lewis on AWR: http://jonathanlewis.wordpress.com/awr-sys-stats/ I found this while looking for how to...
0 views0 comments
kyle Hailey
Jun 16, 20111 min read
5 days left to vote for sessions at Oracle OpenWorld 2011 on Oracle Mix
Oracle has opened Suggest-a-Session on Oracle Mix. Suggest-a-Session is your opportunity to both submit your own presentation ideas as...
2 views0 comments
kyle Hailey
May 31, 20112 min read
Block Change Tracking setup and measurement
For everything you ever wanted to know about Block Change Tracking (BCT) and were afraid to ask, check out the awesome presentation from ...
11 views0 comments
bottom of page