Unix Technical Forum

32 bit oracle on Solaris 9 64 bits ?

This is a discussion on 32 bit oracle on Solaris 9 64 bits ? within the Oracle Database forums, part of the Database Server Software category; --> I just bought a new sun server (280R) and I plan to run solaris 9 on it in 64 ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-22-2008, 06:41 PM
Guy Dallaire
 
Posts: n/a
Default 32 bit oracle on Solaris 9 64 bits ?

I just bought a new sun server (280R) and I plan to run solaris 9 on it in
64 bits mode,
which I think is the default when you install (Can anyone confirm this ?)

Should I run oracle 64 bits edition on it, or would oracle 32 bits edition
run just fine ?

I heard that the 64 bit edition was slower and I don't need a HUGE SGA, and
I will probably
have older 32 bit oracle OCI apps running that I cannot recompile.

Is there a HUGE performance penalty in running 32 bits apps on solaris 64
bits ?

Thanks


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-22-2008, 06:41 PM
Sean Chang
 
Posts: n/a
Default Re: 32 bit oracle on Solaris 9 64 bits ?

Comments inline.

> I just bought a new sun server (280R) and I plan to run solaris 9 on it in
> 64 bits mode,
> which I think is the default when you install (Can anyone confirm this ?)


Yes, 64-bit is the default. You should never change to 32 bit OS



>
> Should I run oracle 64 bits edition on it, or would oracle 32 bits edition
> run just fine ?


We run an Oracle DB of 32 bits in 64-bits Solaris (8 ,9) for more
than 2 years now. Performace is good, also very stable.


> I heard that the 64 bit edition was slower and I don't need a HUGE SGA,

and
> I will probably
> have older 32 bit oracle OCI apps running that I cannot recompile.
>
> Is there a HUGE performance penalty in running 32 bits apps on solaris 64
> bits ?>

Don't know that becuase I have no comparisons.

sean chang




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-22-2008, 06:41 PM
Joel Garry
 
Posts: n/a
Default Re: 32 bit oracle on Solaris 9 64 bits ?

"Sean Chang" <sean@cnfei.com> wrote in message news:<3fa2908e_3@corp.newsgroups.com>...
> Comments inline.
>
> > I just bought a new sun server (280R) and I plan to run solaris 9 on it in
> > 64 bits mode,
> > which I think is the default when you install (Can anyone confirm this ?)

>
> Yes, 64-bit is the default. You should never change to 32 bit OS
>
>
>
> >
> > Should I run oracle 64 bits edition on it, or would oracle 32 bits edition
> > run just fine ?

>
> We run an Oracle DB of 32 bits in 64-bits Solaris (8 ,9) for more
> than 2 years now. Performace is good, also very stable.
>
>
> > I heard that the 64 bit edition was slower and I don't need a HUGE SGA,

> and
> > I will probably
> > have older 32 bit oracle OCI apps running that I cannot recompile.


Oooh, scary Halloween! :-O

They are supposed to work, but those shared libraries... you just
never know until you try. Hopefully it will only be an issue when
recompiling.

> >
> > Is there a HUGE performance penalty in running 32 bits apps on solaris 64
> > bits ?>

> Don't know that becuase I have no comparisons.


http://www.sun.com/sun-on-net/itworl...51101perf.html

Metalink Note:107201.1 says "32-bit databases run on systems with a
small number of 32-bit CPUs (4-6) may see some degradation in
performance if moved to 64-bit systems also with a small number of
64-bit CPUs.

Applications will achieve the benefits of improved scalability on-64
bit machine only if they are memory intensive. 64-bit applications
have bigger data structures because memory has to be addressed with a
larger number of bits. Larger data structures translate into
addtional memory requirements per process.
....

When running 32-bit Oracle binaries on a 64-bit machine, you will have
to set SHMMAX to 1GB exactly. This is an important requirement when
you want to extend the SGA beyond the 1GB. "

Note that you can have a huge SGA with 64-bit, if you can afford the
physical memory and checkpointing penalties. The general idea is that
not having to go to disk is an advantage over the penalties. For the
same init.ora configuration, 64 bits will need more physical memory.

http://metalink.oracle.com/metalink/..._id= 209766.1

Watch the Oracle certification matrix for bit availability when
upgrading.

http://metalink.oracle.com/metalink/...p_id= 62290.1

My general bias is spring for the physical memory and run 64 bit,
since most businesses eventually want to calculate things. And don't
run unsupported software that has no ability to recompile/reinstall.

jg
--
@home.com is bogus.
http://www.infoworld.com/article/03/...sgoogle_1.html
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 02-22-2008, 06:44 PM
Guy Dallaire
 
Posts: n/a
Default Re: 32 bit oracle on Solaris 9 64 bits ?

Thanks a lot for your time.

"Joel Garry" <joel-garry@home.com> a écrit dans le message de
news:91884734.0310311515.53b884d2@posting.google.c om...
> "Sean Chang" <sean@cnfei.com> wrote in message

news:<3fa2908e_3@corp.newsgroups.com>...
> > Comments inline.
> >
> > > I just bought a new sun server (280R) and I plan to run solaris 9 on

it in
> > > 64 bits mode,
> > > which I think is the default when you install (Can anyone confirm this

?)
> >
> > Yes, 64-bit is the default. You should never change to 32 bit OS
> >
> >
> >
> > >
> > > Should I run oracle 64 bits edition on it, or would oracle 32 bits

edition
> > > run just fine ?

> >
> > We run an Oracle DB of 32 bits in 64-bits Solaris (8 ,9) for more
> > than 2 years now. Performace is good, also very stable.
> >
> >
> > > I heard that the 64 bit edition was slower and I don't need a HUGE

SGA,
> > and
> > > I will probably
> > > have older 32 bit oracle OCI apps running that I cannot recompile.

>
> Oooh, scary Halloween! :-O
>
> They are supposed to work, but those shared libraries... you just
> never know until you try. Hopefully it will only be an issue when
> recompiling.
>
> > >
> > > Is there a HUGE performance penalty in running 32 bits apps on solaris

64
> > > bits ?>

> > Don't know that becuase I have no comparisons.

>
> http://www.sun.com/sun-on-net/itworl...51101perf.html
>
> Metalink Note:107201.1 says "32-bit databases run on systems with a
> small number of 32-bit CPUs (4-6) may see some degradation in
> performance if moved to 64-bit systems also with a small number of
> 64-bit CPUs.
>
> Applications will achieve the benefits of improved scalability on-64
> bit machine only if they are memory intensive. 64-bit applications
> have bigger data structures because memory has to be addressed with a
> larger number of bits. Larger data structures translate into
> addtional memory requirements per process.
> ...
>
> When running 32-bit Oracle binaries on a 64-bit machine, you will have
> to set SHMMAX to 1GB exactly. This is an important requirement when
> you want to extend the SGA beyond the 1GB. "
>
> Note that you can have a huge SGA with 64-bit, if you can afford the
> physical memory and checkpointing penalties. The general idea is that
> not having to go to disk is an advantage over the penalties. For the
> same init.ora configuration, 64 bits will need more physical memory.
>
>

http://metalink.oracle.com/metalink/..._id= 209766.1
>
> Watch the Oracle certification matrix for bit availability when
> upgrading.
>
>

http://metalink.oracle.com/metalink/...p_id= 62290.1
>
> My general bias is spring for the physical memory and run 64 bit,
> since most businesses eventually want to calculate things. And don't
> run unsupported software that has no ability to recompile/reinstall.
>
> jg
> --
> @home.com is bogus.
> http://www.infoworld.com/article/03/...sgoogle_1.html



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:27 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com