Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> contiguous SGA?
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 500Received on Thu Aug 12 1999 - 12:28:48 CDT