Re: memory

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 23 Jul 2001 18:22:24 -0700
Message-ID: <9jiikg01fq6@drn.newsguy.com>

In article <3B5C956E.EF0B9893_at_memphis.edu>, Raj says...
>
>What is the max memory that an oracle database can address?

it is OS dependent totally. Windows -- typically 2gig but it can be larger. On Unix, 32 bit -- typically somewhere between 1.75-2gig. 64 bit -- you name it, just keep adding it, we can address it.

>What is the max no. of cpu's oracle can handle (or is this simply OS
>dependent)?

generally 64 is the biggest machine I've seen unless you go with a cluster. Traditional SMP is the limiting factor on a single box.

>How many objects can an oracle database have? If it is unlimited, then
>what is its practical limiting factor E.g. storage area.
>

it is unlimited and I've never seen a database fall over with too many objects. That aside -- don't go out of your way to create an explosion of objects.

>raj
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Mon Jul 23 2001 - 20:22:24 CDT