Perhaps it might be best to suggest that it is a good idea to understand
the *fundamentals* before learning to rely on (semi-)automated tools. This
way, you understand where the tools are (probably) getting their
information, and perhaps better understand the nature and quality of advice
they provide.
Something else that one has to be prepared for is the possibility that the
tools we might (otherwise) be taught to rely upon may not be available.
There are no advisors available in Standard Edition, and you can't even use
AWR (even though it is there).
Tools are great. I, for one, am always happy to use them when they are
available -- and when it is appropriate. On the other hand, I don't think
Oracle (or anybody else) has yet produced a "tool" that can tell me that
the real reason a particular query is under-performing is that the data
model is wrong.
If somebody offered me free access to the Oracle University performance
tuning course, I would certainly attend it -- I bet there is probably no
better or easier way to learn how to use the suite of tools Oracle makes
available. But if I were spending my own money (and could therefore only
afford to take one course), I would probably choose one that concentrates
on fundamentals and (manual) methods that can be applied anywhere. Once
you know how to tune manually, the tools will surely be relatively easy to
pick up when you have them.
On Fri, Aug 21, 2015 at 3:29 PM, Stefan Koehler <contact@xxxxxxxx> wrote:
Hi Raza,
please don't get me wrong. I am not claiming to type long hand commands or
to do a lot of manual analysis just to satisify some ego or to prove
anything. It does not matter, if you use Enterprise Manager, SQL
Developer, TVD$XTAT, Snapper, SQLd360 or whatever.
at the end of the day, your time actually belongs to the organizationpaying for your time. They'd rather have you complete the task expeditiously
I totally agree with you and in course of this it is important to focus on
the business needs. You need to gather properly scoped diagnostic data and
execute the tasks with the greatest net pay off to the business. But this
is all about methodology and not primarily about tools. If you just get
trained on how to interpret an Enterprise Manager graph in case of CPU,
I/O consumption or whatever, you probably gonna fail with this task,
especially as some (possible) important components are not accounted as
database time at all, but may hurt the end users the most.
There is a business reason why tools are created. Unless you want towork for yourself..your choice is what serves your employers interests first
and foremost.
Absolutely and i do not claim not to use tools, but it makes no sense just
to train these tools. My field experience (with clients using Enterprise
Manager for example) shows that a lot of work time is just spent to reduce
CPU time or wait event <X> without even knowing how much time is spent on
each component for the whole business process. Does it make sense to
reduce just a few secs of CPU time for a SQL (because Enterprise Manager
shows
high CPU usage for this SQL), if most/all of the end user response time is
spent in the application layer or in inter-communication between app and
database / app implementation? I hope you would agree with me that it
makes no sense, even if some graphs show high CPU bars ;-)
Funnily this is the same discussion and persuading that i have to do with
clients who just get trained on some tools, but in the end the properly
gathered and scoped diagnostic data are convincing :-)
Finally all i wanted to say is the following:
1) Train methodology and understanding of performance
2) Train the prober tools for point 1
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: @OracleSK
raza siddiqui <raza.siddiqui@xxxxxxxxxx> hat am 21. August 2015 um21:16 geschrieben:
frame the situation as follows:
Though we don't want to get into a shouting match, but I'd prefer to
which one are you going to pickup and use ?
if you have access to an electric and manual drill / screwdriver etc,
and why, but at the end of the day, your time actually belongs to the
Yes - there is a valid argument for understanding what is being done
organization paying for your time. They'd rather have you complete thetask expeditiously, than satisfying your ego because you typed the command
longhand, rather have a tool generate it for you.3 commands - and it'll get it done right, whereas figuring-out indvidual
Another key example.
You need to recover your crashed database. RMAN will require minimum of
commands, and correct sequence to issue them...well you can explain themess to your boss.
work for yourself..your choice is what serves your employers interests first
There is a business reason why tools are created. Unless you want to
and foremost.--
My $0.02
//www.freelists.org/webpage/oracle-l
