Re: project.max-shm-memory
- From: "Keith Moore" <kmoore@xxxxxxxxxxxx>
- To: raindoctor@xxxxxxxxx
- Date: Fri, 28 Sep 2007 13:37:47 -0500 (CDT)
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.
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts: