Re: Memory usage - V7 vs V8

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Fri, 26 Feb 1999 16:53:51 +0000
Message-ID: <36D6D19F.81BEE46A@rdbms.freeserve.co.uk>

Jack,

Can you give a breakdown of the SGA settings ie

SVRMGR> show sga

Total System Global Area                         27205632 bytes
Fixed Size                                          49152 bytes
Variable Size                                    13877248 bytes
Database Buffers                                 13107200 bytes
Redo Buffers                                       172032 bytes

Chris.

Jack Jolly wrote:
>
> Has anyone noticed that V8 seems to need more memory than V7? With V7 I had
> DB_BLOCK_BUFFERS set to around 5000 and had an SGA of roughly 10M. With V8
> I have DB_BLOCK_BUFFERS cranked down to 1000 and have a 12M SGA.
>
> JJ
> ===========================================================
>
> Jack G. Jolly
> Intergraph PDS Support
> jgjolly_at_ingr.com, (256) 730-3100
Received on Fri Feb 26 1999 - 10:53:51 CST