Online is RAM-Hungry
Posted in 1997
I've been called in to troubleshoot an Online installation. The problem
is that upon startup, Online immediately starts to "dynamically"
allocate additional shared memory segments. The logfile shows 10
allocations of 8,388,608 additional memory segments (A whopping
additional 83 Meg!). I'm not sure how this is possible, given that
SHMVIRTSIZE is set to 64,536 (64 Meg?) - the system only has 96 meg of
memory total.
Another weird thing is that they've got their chunks pointed to
"/dev/dsk"-Block slices, rather than "/dev/rdsk"-Character slices. I'm
not sure what affect this has, but the DB seems to be running ok. I've
never seen that before...
In their Onconfig file, I can't seem to find anything that would need to
have 83 additional MB of memory. The following are the possibly
meaningful differences I've found. I'd appreciate it if anybody would
let me know if they see anything that looks like it might be causing the
prolem.
theirs onconfig.std
------ ------------
PHYSFILE 2560 1000
SERVERNUM 7 0
BUFFERS 1024 200PHYSBUF 2560 32
LOGBUFF 2560 32USERTHREADS no entry 100
TRANSACTIONS no entry 100
TBLSPACES no entry 200
CHUNKS no entry 8
DBSPACES no entry 8
SHMVIRTSIZE 64536 8000TIMEOUT 0x12c 300
STACKSIZE 256 32PDQPRIORITY 10 0
(dual-processor machine, but only 1 CPU enabled)
--
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Blah Blah Lounge - "Do You Have Something Smart To Say?"
Cosmo Lee email: cosmo@echonyc.com Brooklyn, NY
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *