Hmmm. I should have asked that last over the phone interview for that
prospective job what hardware platform they run their databases on.
They claimed all their database is cached in memory, as in "all". I
know they use Linux, but on what hardware platform. 3GB buffer cache
(less than this since PGA, sort area, log buffer takes some space too)
does not give you a lot of data, does it? It's equivalent to a 3GB
hard drive full of Oracle data. 3GB hard drives are what, a 5 year old
technology? 3GB of Oracle data, translates to how many rows, columns,
tables (roughly)??
--
Lyndon Tiu
Quoting Chuck Hamilton <chuckh_at_softhome.net>:
> By default, Windows imposes a 2g per process limit on all
> processes
> including the OS itself. Oracle runs as a process with each session
> running
> as a thread within that process so the entire Oracle process
> including SGA,
> sessions, DLLs, executables, etc. must all fit within 2g. There is
> a
> boot.ini switch that raises the limit to 3g while reducing the
> OS's
> addressable memory to 1g.
>
> I can't speak to other 32 or 64 bit platforms from experience as
> I've never
> tried to push any of them to the limit.You need to remember though
> that
> X-bit processor doesn't necessarily mean X-bit addressability.
> Unless I'm
> mistaken the bit size of a processor represents the size of the
> registers,
> instructions and internal busses, but not the memory addressability
> which is
> limited by other things in the hardware. Having said that, current
> 32 bit
> platforms can usually addresses 4g.
> --
> Chuck
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, February 28, 2003 12:34 PM
>
>
> > Hello,
> >
> > 1) How big (max) can an Oracle SGA be in a 32bit platform
> (Windows and
> > Linux on ia32)?
> >
> > 2) How big (max) can an Oracle SGA be on a 64bit platform
> (Sparc
> > Solaris, AIX PowerPC)?
> >
> > Thanks.
> >
> > --
> > Lyndon Tiu
> >
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Lyndon Tiu
> > INET: ltiu_at_alumni.sfu.ca
> >
> > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting
> services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail
> message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
> in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You
> may
> > also send the HELP command for other information (like
> subscribing).
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Chuck Hamilton
> INET: chuckh_at_softhome.net
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting
> services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
> in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You
> may
> also send the HELP command for other information (like
> subscribing).
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Lyndon Tiu
INET: ltiu_at_alumni.sfu.ca
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Feb 28 2003 - 13:47:12 CST
