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

> 1) How can I tell if the Oracle server is running in 64-bit mode. There is
> no indication in the output of, for example, svrmgrl. Is there a way?
> Is there a command I can run?

Just logon to SQL*plus and watch the banner. For 64 bit Oracle it says so.

> 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.
> Am I missing something here? I thought the more the memory the better?
> (there's not much else running on the Unix server, so we won't be
> affecting other processes).

Large SGA is not a problem. But you should not allocate more than 30% for the RAM persent in your system to SGA. Having said that, you should also look
for any paging activity going on.

Thanks,
Saikat Chakraborty

-- 
Posted from [203.197.125.243] 
via Mailgate.ORG Server - http://www.Mailgate.ORG