All the types and vendors of training I've seen on this thread have merits in
the right situation, and Stéphane didn't bother mentioning that he is also in
the top tier of folks who educate about using RDBMS technology well. Either he
is being modest or he assumes you know of him well enough.
Another type of education that fills a very specific niche is a consulting
service that specializes in technology transfer in conjunction with solving a
site specific challenge (whether it is performance, modification of function,
or both.) Technology transfer in this regard should be geared to filling gaps
of the incumbents, whether it be improvement in communications about the data
model amongst the need definers, the developers, and the dbas, developing a
useful method for solving specific challenges, or developing a method for
identifying which performance challenges are important to users. (I'm biased
toward maximizing throughput methods to try to keep batch type work from
intruding on highly interactive window and using Method-R to identify
interactive service insufficiencies. I've been using essentially Method-R
combined with workload and workshift load matching to available resources since
before Cary and Jeff described it carefully and documented it in a wonderful
book. Understanding what the pacing resource is after you have identified a
problem service or a batch job that shouldn't (but does) intrude on interactive
windows is another bit you have to master if you would like to not only
identify problems but solve them (either by revising the service so it uses
less of the pacing resource or by arranging more of that resource.)
// start ad We at Rightsizing, Inc. like to think that we are particularly good
at the "solve one or a few specific problems while teaching the incumbents"
school of education. This educational method has the advantage of tuning what
is taught by observing the problems you are having difficulty solving. //end ad
The real point I'm trying to make is that the venues available for really top
notch education in the use of Oracle technology are rich and varied. Apart from
some notoriously bad educators (none of whom are yet mentioned on this thread)
there are some really high quality opportunities from professional educators to
users group meetings to Oracle University. I should also mention John King and
Kent Graziano - if you need to know about something they teach, they are very
good. Finally the free stuff being championed by Oracle employee "evangelists"
for example Steven Feuerstein is super if you've gotten to a level where you
get it why the things he is pointing out are important.
Sorry I don't have a magic bullet about which "Oracle DB performance tuning
training" is best. Sigh. It depends.
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Stéphane Faroult
Sent: Saturday, August 22, 2015 8:42 AM
To: contact@xxxxxxxx; sethmiller.sm@xxxxxxxxx
Cc: oracle-l
Subject: Re: Oracle DB performance tuning training
From my field experience with clients - they usually take the following
from such a class:
1) End user complains about performance
2) Look at top wait events in graphical representation in EM or top
section in AWR in this time window
3) Analzye and reduce it with the mentioned and trained tools
4) Result = Happy end user
... and we all know that this does not work out well in an effective
way (otherwise we would be jobless). A lot of work time in
organizations is wasted on tuning wait event <X> without any notice
to the complaining end users, just because of some tools show some
high colorful graphs :-)