Re: project.max-shm-memory

It is the sum off all the SGA shared memory segments. That's assuming all the instances are running under the same user or at least under the same project.

If each instance is under a separate project, then you need to set the value for each project and it only applies to shared memory segments in that project.

I don't think Oracle makes this very clear in their installation guide.

"id -p" will show you the project name
"prctl -n project.max-shm-memory -i project <project name>" will show the current setting.

Keith

> Solaris 10, sparc 64bit, 10.2.0.3 oracle; 6 oracle instances running
> on this zone.
>
> Is there any thumb rule to set max-shm-memory? Is it a sum of all
> sga_target + pga_aggregate_target?
>
> Thanks,
> Pedro.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l