HI Gael Yes, I know this already. I've already used the resource control facility and setup a project with the project.max-shm-memory. However, Oracle requires 40% of memory upon booting up. THAT is my major problem. I'm trying to change the required 40% of RAM for Oracle boot up, to something like 20% RAM. Thanks for the response. I'll keep on searching... Anne
_____ From: Gael [mailto:[EMAIL PROTECTED] Sent: Sunday, March 16, 2008 10:50 AM To: Anne Moore Cc: [email protected] Subject: Re: [zones-discuss] can non-zones see less RAM than global? >From the oracle 10G doc.... you will need to use (and adapt) these project entries to your needs... In Solaris 10, you are not required to make changes to the /etc/system file to implement the System V TPC. Solaris 10 uses the resource control facility for its implementation. Parameter Replaced by Resource Control Recommended Value noexec_user_stack NA 1 semsys:seminfo_semmni project.max-sem-ids 100 semsys:seminfo_semmsl process.max-sem-nsems 256 shmsys:shminfo_shmmax project.max-shm-memory 4294967295 shmsys:shminfo_shmmni project.max-shm-ids 100 Regards On Sun, Mar 16, 2008 at 9:38 AM, Anne Moore <[EMAIL PROTECTED]> wrote: <<I doubt it. If Oracle is taking 1/2 of physical memory by default, it will probably do so whether you have 4GB or 40GB.>> Probably so. But I'm using Zones here, so it may be a different story all together. <<page 94 of http://www.sun.com/blueprints/0505/819-2679.pdf has tunables for Oracle 9>> Thanks. I'm using Oracle 10g 2. I'll see if I can find a article for that. (Unfortunately, I don't have a sun solve service plan!) Thanks for the help Anne -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steffen Weiberle Sent: Sunday, March 16, 2008 10:12 AM To: [email protected] Subject: Re: [zones-discuss] can non-zones see less RAM than global? Anne Moore wrote: > <<customers have run multiple instances of Oracle in a single Solaris > instance, even without zones.>> > > That's probably because they have massive amounts of memory installed. > Unfortunately, we don't. I doubt it. If Oracle is taking 1/2 of physical memory by default, it will probably do so whether you have 4GB or 40GB. > > I can't find any Oracle experts who know how to tune the memory > requirements... ugh. In fact, the one's I have spoken to don't know if > it's even possible. page 94 of http://www.sun.com/blueprints/0505/819-2679.pdf has tunables for Oracle 9. > > Thanks for your response. > > Anne > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Steffen > Weiberle > Sent: Sunday, March 16, 2008 9:48 AM > To: [email protected] > Subject: Re: [zones-discuss] can non-zones see less RAM than global? > > Mike Gerdts wrote: >> On Sat, Mar 15, 2008 at 8:22 PM, Gael <[EMAIL PROTECTED]> wrote: >> >>> Mike, >>> >>> The OS will still display the whole amount of RAM with these RM >>> entries ... You cannot use it, but the installation scripts and >>> other tools using the usual OS command will still see the real RAM >>> and configure their stuff as is ... >>> >>> Sun Microsystems Inc. SunOS 5.10 Generic January 2005 >>> # prtconf >>> System Configuration: Sun Microsystems sun4u Memory size: 1536 >>> Megabytes System Peripherals (Software Nodes): >>> prtconf: devinfo facility not available # >> When I did testing on Nevada (not S10) vmstat gave results that were >> in line with the resource controls. I did notice that df would >> report an improperly large size for /tmp, which is another problem. >> Your results suggest that prtconf or the underlying system calls also >> need to be updated to reflect memory resource controls. >> >> I would guess that any of the parameters that Oracle is going to set >> based upon RAM size can be hand-tuned after the installation. > > I would think that you can tune the size of Oracle, probably dominated > by the size of the SGA, even before you install/configure. unless > there is something new Oracle is doing. > > Customers have run multiple instances of Oracle in a single Solaris > instance, even without zones. > > I am not a DBA, otherwise I would offer tuning parameters. > Steffen > > _______________________________________________ > zones-discuss mailing list > [email protected] > > _______________________________________________ > zones-discuss mailing list > [email protected] _______________________________________________ zones-discuss mailing list [email protected] _______________________________________________ zones-discuss mailing list [email protected] -- Gael Martinez
_______________________________________________ zones-discuss mailing list [email protected]
