Re: Performance Issue

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 30 Nov 2006 05:06:51 -0800
Message-ID: <1164892010.884791.150620@f1g2000cwa.googlegroups.com>

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,
> Jitendra

There is no one size fits all answer that can be provided. The correct answer depends on:

* Oracle version
* Available _physical_ memory
* Operating system (to some extent)
* Expected work load: are users only selecting from a single table, are

uses requiring the sorting of very large data sets, will the system be used for mainly batch processes or mainly for OLTP, etc. * Any many others.

Find a suitable starting point and adjust from there based on whether or not expected performance levels are achieved. A Google search should provide very general recommendations that can be used as a starting point. If you do not expect to use Java, set the Java Pool to a small value, such as 1MB.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Thu Nov 30 2006 - 07:06:51 CST