I have a question regarding how the HP3000 allocates and uses the Oracle SGA
memory.

Should the SGAUTIL allocation be very closely matched to that used by the
actual database?

I know what happens if SGAUTIL space is too small - the database failes to
start.  But what if it is too big?  Is this "preallocated" space wasted
space within the HP3000 memory?

eg. in the following example, I have displayed SGAUTIL, and the SGA for the
XX database.  Are we totally wasting approx 13.2 Meg (ie. 32 Meg - 18.8
Meg)?  If so, I suspect I should take steps to either reduce the SGAUTIL
allocation or utilize it by increasing various init.ora parameters if I
think they will help performance.

Many thanks,
Rodney.

Oracle 7.3.4.4 on MPE/iX 6

Rodney Behrendorff
Data Administrator
Information Technology Services
University of Southern Queensland
Toowoomba Queensland Australia 4352
Email: [log in to unmask]
Tel:  +61 7 46312621
Fax: +61 7 46312798



:sgautil list

SGAUTIL: Release 7.3.4.4.0 - Production on Fri Mar  9 10:35:01 2001
Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.

 SGA RECORD   SIZE(bytes)   SID                  HOME
===========================================================
     1       32000000       XX                  /PROD/ORADB
     2       64000000       YY                   /PROD/ORADB
     3        8000000      ZZZ                   /PROD/ORADB

SGA TOTAL SIZE = 104000000 bytes

SVRMGR> connect internal
Connected.
SVRMGR> show sga
Total System Global Area      18852448 bytes
Fixed Size                       31552 bytes
Variable Size                 18231072 bytes
Database Buffers                573440 bytes
Redo Buffers                     16384 bytes
SVRMGR>