RE: Training for Oracle Performance tuning

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Fri, 28 Sep 2007 10:41:42 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB3097A8C52@x6009a.umb.corp.umb.com>

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 [mailto:Ted.Coyle_at_MEDecision.com] Sent: Friday, September 28, 2007 10:27 AM To: Kerber, Andrew W.; oracle-l_at_webthere.com; fmhabash_at_gmail.com; sunil.kanderi_at_gmail.com
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. (http://www.bookpool.com/ss?qs=guerrilla+capacity+planning&x=14&y=9)

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 28 2007 - 10:41:42 CDT