Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sun Solaris 2.6/5.6, Oracle 8.0.6 and SHMMAX

RE: Sun Solaris 2.6/5.6, Oracle 8.0.6 and SHMMAX

From: Lord David <DLord_at_axis-resources.co.uk>
Date: Wed, 5 Jul 2000 09:04:18 +0100
Message-Id: <10549.111198@fatcity.com>


Where are you getting your 'value recommended by Oracle' from? According to the installation guide (for 8.1.5, but I'm sure that it is similar on 8.0), SHMMAX should be set to 0.5 * (physical memory present in machine) - in your case, 512Mb. I suspect that if you try to run an SGA bigger than physical memory, you are in for a whole world of pain with paging and swapping.

Regards
David Lord
Senior DBA, Axis Resources, Cardiff.

> -----Original Message-----
> From: S. Anthony Sequeira [mailto:Sequeira_at_lineone.net]
> Sent: 04 July 2000 23:04
> To: Multiple recipients of list ORACLE-L
> Subject: Sun Solaris 2.6/5.6, Oracle 8.0.6 and SHMMAX
>
>
> Hi,
>
> I have come in to a site where Oracle 8.0.6 is installed on a Sun
> Solaris (2.6/5.6) machine with 1GB RAM 2GB swap.
>
> The SHMMAX kernel parameter is set to 25% of the value recommended
> by Oracle.
>
> The customer claims that when they set it to Oracle's recommended
> value, it refused to boot (the kernel panicked). They also claim that
> they were told by Sun support that Oracle's recommended value
> (approximately 4GB), is too large for a machine with only 3GB memory
> (including swap).
>
> I am sure that I have managed to set this parameter to Oracle's
> value on machines with less memory than this one, but I may be wrong.
>
> Any comments?
>
> TIA.
>
> Tony
> --
> S. Anthony Sequeira
>
> Wait for the ricochet
>
> Opinions expressed herein are my own and do
> not necessarily represent those of my employer
>
>
>
> --
> Author: S. Anthony Sequeira
> INET: Sequeira_at_lineone.net
>



This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com


Received on Wed Jul 05 2000 - 03:04:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US