Re: Oracle creates multiple shared memory segments despite SGA < SHMMAX
Date: Fri, 6 Mar 2009 05:58:57 -0800 (PST)
On Mar 5, 4:15 pm, ca111..._at_gmail.com wrote:
> This is new installation of 10.2.0.4 on HP-UX 11.23 Itanium.
> HP-UX kernel parameter SHMMAX is 10G,
> Oracle parameter SGA_MAX_SIZE set to 8G.
> On startup Oracle creates 4 shared memory segments, size in bytes:
> Any idea why?
> Yes I know that it *should* run OK with multiple shared memory
> and I am aware that it is normal to create segments with different
> (Metalink Note 15566.1). Still I would prefer to have one segment, not
> There is only one instance on this server, there is no other software
> that uses IPC (Tuxedo, etc), Oracle started immediatelly after server
> The only kernel parameter set to 4G is MAXDSIZ_64BIT. As far as I
> it shouldn't affect sizing of shared memory segments.
You're looking in the wrong place, I think, since this server could be configured for non-uniform memory access (NUMA) which would create multiple shared memory segments. Possibly you should ask your Sys Admin how the box is built; he or she may have the answers you seek.
David Fitzjarrell Received on Fri Mar 06 2009 - 07:58:57 CST