Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> contiguous SGA?

contiguous SGA?

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Thu, 12 Aug 1999 13:28:48 -0400
Message-ID: <37B3044F.FDFEFBB8@bigfoot.com>


Anyone familiar enough with AIX to point me in the right direction as far as making
the SGA one contiguous segment in memory? A small tuning guide with our latest
box of stuff from Oracle says perfomance increases can be from 0 to 10%.

I use the ipcs -bm command, and note that the SGA is in several pieces, and I'm not
sure wether I can tell wetheri it's contiguous...

Here's the output...

IPC status from /dev/mem as of Thu Aug 12 11:31:38 1999 T ID KEY MODE OWNER GROUP SEGSZ Shared Memory:

m1662976 0x0f3d034c --rw-r-----   oracle      dba 268435456
m 114689 0x173d034c --rw-r-----   oracle      dba 268435456
m1961986 0x23fc5aac --rw-r-----   oracle      dba 268435456
m3813379   00000000 --rw-r-----   oracle      dba  62197760
m 118788 0x0000f6a1 --rw-rw----    psoft  payroll    292096
m      5 0x0d05f122 --rw-rw-rw-     root   system      1440
m1191942 0x1f3d034c --rw-r-----   oracle      dba 268435456
m 122887 0x273d034c --rw-r-----   oracle      dba 268435456
m 114696 0x0000f407 --rw-rw----    psoft  payroll    285600
m 114697   00000000 --rw-------    psoft  payroll       632
m 118794 0x2f3d034c --rw-r-----   oracle      dba  71802880
m 114699 0x0000a2bf --rw-rw----    psoft  payroll    224380
m 114700   00000000 --rw-------    psoft  payroll       484
m     13 0x00000790 --rw-rw-rw-     root   system      4008
m     14 0x00001515 --rw-rw-rw-     root   system        16
m  98319 0x6305080c --rw-rw-rw-   rsmith    staff     16384
m 159760 0xffffffff --rw-------    psoft  payroll       652
m 151569 0x1d15b800 --rw-r-----   oracle      dba 138612736
m  53266 0x000098ea --rw-rw----    psoft  payroll    229492
m   4115 0xffffffff --rw-------    psoft  payroll       500


Received on Thu Aug 12 1999 - 12:28:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US