Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is up with ISM?
In article <6l8oru$l5j_at_nnrp3.farm.idt.net>, "No Spam Please" <nospam_at_foo.bar> wrote:
> My question is does ISM really provide that much of a
> performance boost and, if so, when will Sun provide
> it or why don't they provide it?
As far as Oracle is concerned, the main effect of ISM is to lock shared memory segments in RAM, so your SGA won't get paged out. In an ideal world, this won't make a big difference, because you'll have enough RAM to hold all your active processes and your SGA. Even in the real world, your SGA will usually get hit often enough to keep it in RAM, anyway, even though idle processes are getting swapped out. In general, if your SGA does get paged out, either it's too big, or you need more memory.
IOW, ISM is nice, and its absence *might* be the cause of your performance problems, but it generally won't make that much difference, so I'd suggest that you look elsewhere.
Lastly, ISM is only available on the Sun4m architecture because that's the only system that has the hardware to support it; AFAIK, it will never be available under Sun4u systems. Received on Tue Jun 09 1998 - 00:00:00 CDT