Depends upon the OS. 32 bit OS is probably limited to 2 gigs of ram and 64
bit os is probably limited by your pocketbook (I've heard of 500 gig ram for
a database).
It will use all the cpu's that the OS allows and that you have.
There is probably a limit. Since the largest the database can be is
something like 500 petabytes. (a petabyte is 1000 terabytes) And since I
think a tablespace is limited to something like a 1,024 files (and there can
only be 1024 tablespaces I think) and the system tablespace has a
limitation. But the number would be huge.( 488 terabytes per tablespace and
if each object takes up 1K (probably less) then there is proabably a limit
of around 500,000,000,000 objects which seems adaquate for most purposes.
If each object only takes 500 bytes then we have 1,000,000,000,000 objects.
Jim
"Raj Manickavasagam" <rajm_at_memphis.edu> wrote in message
news:3B5C956E.EF0B9893_at_memphis.edu...
> What is the max memory that an oracle database can address?
> What is the max no. of cpu's oracle can handle (or is this simply OS
> dependent)?
> How many objects can an oracle database have? If it is unlimited, then
> what is its practical limiting factor E.g. storage area.
>
> raj
>
Received on Mon Jul 23 2001 - 20:02:54 CDT
