Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Proposal for Tuning Project!!

Re: Proposal for Tuning Project!!

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 12 May 2006 06:29:30 -0700
Message-ID: <1147440570.688451.193260@i40g2000cwc.googlegroups.com>

jsfromynr wrote:
> Hello All,
>
> I may be asking a question at the wrong place.
> It is easier to find the cost/effort for a software development
> project.
>
> How to find the cost/effort of an database tuning project?
> How one ca safely state the % improvement possible in tuning objects?
> Is giving micro level performance improvement is good or giving a macro
> view of it? like should one say that if x object (view / procedure) is
> changed it will result in x% of improvment or it is better to say that
> performance will improve by x% for the application?
>
>
> Any help is appreciated

I recommend obtaining Cary Millsap's book "Optimizing Oracle Performance" it should point you in the right direction.

It is much better to target performance improvement projects that will benefit the business and the goal should be improving/reducing/eliminating response time problems. Received on Fri May 12 2006 - 08:29:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US