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 <[EMAIL PROTECTED]>: > 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" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
