Re: Problem with Oracle SGA larger than 1GB

Alex

I don't know exactly why you're trying to use so much of the machine resources for the shared pool, but make sure you don't leave yourself short for db_block_buffers, log_buffers, user processes etc. I wouldn't take the entire SGA size past 3 Gb, and you're attempting to use that amount of memory for just part of it. How much SQL are you loading in the shared pool? 3 Gb sounds incredibly high and probably unnecessary. Not the answer you were after, I'm sure, but worth thinking about.

Pete

Alexander Schiftner wrote:

> I am trying to increase the shared_pool_size of my Oracle-Instance to about 3GB.
> When starting up the instance,
> Oracle is not able of attaching the shared memories. I am using Oracle 7.3.4 on
> a NCR S50 with NCR-Unix MP-RAS 3.02. Since the S50 is configured with 4GB of
> RAM, I would like to use 3GB of it for the Oracle-Instance, to improve
> performance.
> Is there anyone who knows such problems?
> Please help!!!
>
> Alex Schiftner
>
> --
> -----------------------------------------------------------------------------
> | AUSTROSOFT (R) Weiss
> | Datenverarbeitung GmbH
> Email: | Lilienberggasse 13
> Alexander Schiftner <weissdv_at_via.at> | A -1130 Wien, Austria
> | Telephon: +43 1 877 62 05-17
> | Fax: +43 1 877 62 05-21
> -----------------------------------------------------------------------------

Received on Fri Aug 27 1999 - 10:50:01 CDT