Re: huge sga

From: Bao Phan <baophan_at_nmmcc.com>
Date: Fri, 5 Jun 1998 21:15:25 -0600
Message-ID: <6lace8$epe$1@sloth.swcp.com>

Hi Ed,

It depents on your database usage, you need to utilize those 2 parameters differently. I suggest you set the SGA and db_block_buffers to a low number initially then monitor the cache hit rates (data dictionary, library cache hit rate and data buffer) and adjust them accordingly.

Bao Phan - DBA
NMMCC Ed Lufker wrote in message <6l4djm$pgs$1_at_sloth.swcp.com>...
>Hi All;
>
> Does a shared pool size of 150000000 and db_block_buffers set to
>150000 seem unrealistic for a db that has over 2000 indexes and about 450
>tables. This creates about a 1.2GB sga.
>
>
>thanks for any help here.
>eddie lufker
>
Received on Fri Jun 05 1998 - 22:15:25 CDT