Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Training for Oracle Performance tuning - Method-R is easy

Re: Training for Oracle Performance tuning - Method-R is easy

From: Vlad Sadilovskiy <>
Date: Fri, 28 Sep 2007 14:23:01 -0400
Message-ID: <>

Two thumbs up to the Andrews point of view!! However any particular business hardly depends on ones philosophy. My vision is that planning, planning and again planning and constant monitoring keeps it running without falling over the edge. In many cases it is too late to tune anything because the business has fallen apart. And not because the DBA didn't monitor or didn't analyze traces. An "explosion" might have started in a different spot. And there were no spare resources to absorb the shock. Technology requires wider (and probably more complex) approach that takes into account all layers not just the metrics that Oracle came up with.

Vlad Sadilovskiy
Oracle Database Tools

On 9/28/07, Kerber, Andrew W. <> wrote:
> Well, there you go. By your answer, you make my point. It's a matter
> of philosophy. Not everyplace I work requires, or even expects, all
> changes to return measurable value to the business. The expectation is
> that by keeping an eye on performance, and continuously improving where
> possible, we increase our capacity and ability. Its not at all unusual
> for me to make a change that will return no measurable improvement right
> now, but at some future date, should we need it, that extra unused
> capacity will be available.
> In some environments, where staffing is low and you are right at the
> edge of capacity all the time, you may not have time to work that way.
> -----Original Message-----
> From: Ted Coyle []
> Sent: Friday, September 28, 2007 10:27 AM
> To: Kerber, Andrew W.;;;
> Cc: oracle-l
> Subject: RE: Training for Oracle Performance tuning - Method-R is easy
> "and are really interested in getting the whole instance running well,
> tuning is an ongoing task that you will never actually finish." --->
> This defines CTD..
> I think the whole focus should be to add value and I'm using it in
> development every day to redirect efforts where we can add the most
> value to our product without trying to "tune everything".
> There is only so much the business is will to tolerate in regard to
> constant "tuning". I think the real difference lies in definition. In
> many cases, tuning is even on the project scope.
> (
> Tuning focuses on speed and optimization focuses on value.
> Every tuning effort should directly relate to business value in every
> situation.
> Can any one process run faster? In most cases yes, but what is the
> value proposition to the business? Hire some FTEs who spend all their
> day looking at dials and numbers spewed from aggregates to say that
> something is good or bad, or get things running as fast as possible
> given the economic value to the business.
> This is a business focused method. It takes economic value for any
> action into account. I think the "tuning" focused Technicians are
> solely responsible for their own bad rap. Never buy the problem.
> Trying to tune everything is buying the problem. Ask the business what
> it wants, but also make sure to defined the target's scope. This way
> the business is happy as long as targets are met. Just make sure the
> targets are attainable and cost-effective. Keep up with system
> patterns, know when something is out-of-bounds, but don't make arbitrary
> adjustments.
> Ted
> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
> _ _
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you
> received
> this message in error, please contact the sender and delete the material
> from any computer.
> ------------------------------------------------------------------------------
> NOTICE: This electronic mail message and any attached files are
> confidential. The information is exclusively for the use of the individual
> or entity intended as the recipient. If you are not the intended recipient,
> any use, copying, printing, reviewing, retention, disclosure, distribution
> or forwarding of the message or any attached file is not authorized and is
> strictly prohibited. If you have received this electronic mail message in
> error, please advise the sender by reply electronic mail immediately and
> permanently delete the original transmission, any attachments and any copies
> of this message from your computer system. Thank you.
> ==============================================================================
> --

Received on Fri Sep 28 2007 - 13:23:01 CDT

Original text of this message