Re: Performance Issue

On Nov 30, 11:53 am, DA Morgan <damor..._at_psoug.org> wrote:
> Jitendra wrote:
> > Hi,
>
> > I have one oracle database,which is used by 50 users at a time.
> > Server mode is DEDICATED and available virtual memory is 5129MB.
>
> > Please suggest me the parameter values as the current database is slow.
> > Parameters like
>
> > 1)Shared Pool
> > 2)Buffer Cache
> > 3)Large Pool
> > 4)Java Pool
> > 5)Aggregate PGA Target etc.
>
> > Thanks and Regards,
> > JitendraNot the way tuning is done. Your problem, for example, might well
> relate to indexing strategy (or lack thereof) or any number of
> other factors.
>
> Buy and read three books:
> 1. Tom Kyte's Effective Oracle by Design ISBN 0-07-223065-7
> 2. Jonathan Lewis' Cost-Based Oracle Fundamentals ISBN 1-59059-636-6
> 3. Cary Milsap's Optimizing Oracle Performance ISBN 0-596-00527-x
>
> These are the minimum required knowledge set for tuning.
>
> Alternatively find someone else who has the appropriate knowledge
> help you.
>
> If you want help from this group my recommendation would be to start
> with posting the DML statements that are slowest along with their
> corresponding EXPLAIN PLANs generated with the verbose version of the
> DBMS_XPLAN built-in package.
>
> HTH
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Couldn't have said it better. Great post!

Parameters do not performance make.... Received on Mon Dec 04 2006 - 15:17:38 CST