Re: How to check if the Oracle server is running in 64-bit mode.

On 19 Jul 2001, lmcstmc_at_lmc.ericsson.se wrote:

> Hi,
>
> I'm running Oracle 8.1.7 on Solaris 8 and am having trouble
> creating an SGA of 2 Gigs. There is enough physical memory and
> /etc/system parameters are correctly set
> (e.g. SHMMAX). metalink notes seem to indicate that a change to
> sgabeg parameters will fix the problem

How much RAM do you have?

> 2) An Oracle support person questioned why I wanted to create
> an SGA of 2 gigs. He said that 80% of the time, large SGAs
> reduce performance.

Well, he might have been told to say something that is really, "you don't want Oracle to take too much of the RAM, maybe 1/3-1/2 is the rule-of-thunb.

> Am I missing something here? I thought the more the memory
> the better?

I do believe this is the case.

-- 
Galen Boyer
It seems to me, I remember every single thing I know.