Re: Online is RAM-Hungry
Online is supposed to dynamically allicate virtual shared memory as needed
by sessions in progress. What is running shen you "startup".
Also, issue onstat -g seg to see how big Virtual portion on shared
memory is at startup. I guess one possibility is that the Online
instance isn't using the config file you think it is.
-Bill
}
} 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 200
} PHYSBUF 2560 32
} LOGBUFF 2560 32
} USERTHREADS no entry 100
} TRANSACTIONS no entry 100
} TBLSPACES no entry 200
} CHUNKS no entry 8
} DBSPACES no entry 8
} SHMVIRTSIZE 64536 8000
} TIMEOUT 0x12c 300
} STACKSIZE 256 32
} PDQPRIORITY 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
} * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
}
--
Bill Ennis Voice: 312-474-7516
SSA Fax: 312-474-7460
500 W. Madison email: ennis@ssax.com ennis@accesschicago.net