T.R | Title | User | Personal Name | Date | Lines |
---|
9613.1 | shm-max is an int (<= 2GB) | ALFAM7::GOSEJACOB | | Fri Apr 25 1997 06:05 | 18 |
| re .0
Hmmm, maybe something changed for 4.0x I'm not aware of but as far as I
know shm-max is limited to 2GB. I just had a look at /usr/include/sys/shm.h
and yes shmmax in shminfo is an int. So the 2GB limit still holds true.
But, and here's the good news, you don't need to set shm-max larger
than 2GB. If you want Oracle to allocate a SGA larger than this limit,
no sweat: the Oracle kernel will automatically allocate as many shared
memory segments as needed to fit the configured size of the SGA.
BTW. don't forget to add the line:
vlm_sga_base_address = 0x400000000
in your init.ora parameter file if your SGA is configured larger than 2GB.
Hope this helps
Martin
|
9613.2 | | COMICS::CORNEJ | What's an Architect? | Fri Apr 25 1997 06:17 | 19 |
| re .1,
Are you sure this is true of all Oracle versions.
A couple of weeks back I helped a customer upgrade from UNIX V3.2C to
V4.0B. I don't know which version of Oracle we had (proibably quite
old) but Oracle UK said it was OK for V4.0B and send a couple of
patches..
After the install, Oracle refused to start. I don't have the syntax
of the messages but it implied not enough memory for the SGA.
We kept upping shm-max until it worked, but when using ipcs we saw that
the SGA was all in one segment , where in V3.2c it had lots of smaller
segments.
Jc
|
9613.3 | more than 1 segment for quite a while | ALFAM7::GOSEJACOB | | Fri Apr 25 1997 08:03 | 13 |
| re .2
I'm sure as far as I can remember back and that would be 7.1.3. What
version of Oracle did the customer use? When they upgraded to 4.0B
where there any shared memory related sysconfitab parameters left over
e.g. gh-chunks? Was new-wire-method set to 0?
There's also a little tool that comes with the Oracle installation,
at no extra charge :-). Try a 'tstshm' when logged in as the Oracle
owner. The output will tell you what the tool tried to allocate
shared segment wise.
Martin
|