Re: How to tune SGA settings in Oracle 8i

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Tue, 19 Feb 2002 17:04:24 GMT
Message-ID: <3C7285A6.6AE06778@ci.seattle.wa.us>

This is no way to set up an Oracle instance. But given that this is what you have to work with I would use Oracle's defaults, have my tuning scripts ready, and plan on working late every night adjusting parameters and bouncing the instance.

Daniel Morgan

Karsten Riedel wrote:

> I have Oracle 8.1.6 on a machine with 1GB RAM. I'm running a server
> application that has about 20 parallel ODBC connections to the database.
> Nothing else is running on that machine.
>
> What are the optomal settings for Shared Pool, Buffer Cache, Large Pool and
> Java Pool? I guess I can keep Java Pool small because I'm using ODBC but I'm
> not sure about the rest.
>
> Thanks in advance
>
> Karsten
Received on Tue Feb 19 2002 - 11:04:24 CST