Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to check if the Oracle server is running in 64-bit mode.
There are two ways to find the bit level with oracle 8i:
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
With the Partitioning option
JServer Release 8.1.6.3.0 - Production.
b. A 64 bit oracle server will return the banner: Oracle Server Manager Release 3.1.6.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.6.1.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.6.1.0 - 64bit Production.
"Saikat Chakraborty" <saikatchak_at_hotmail.com> wrote in message
news:001501c11b07$aee4dd40$03c810ac_at_ibmpiii15...
> > 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
Received on Sun Aug 05 2001 - 16:27:53 CDT