Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: memory

Re: memory

From: Yaroslav Perventsev <p_yaroslav_at_cnt.ru>
Date: Tue, 24 Jul 2001 10:04:33 +0400
Message-ID: <9jj2qh$jg4$1@news247.cnt.ru>

Hello!

Thomas Kyte <tkyte_at_us.oracle.com> ÓÏÏÂÝÉÌ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:9jiikg01fq6_at_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.

No, it's may be default values. But you may relink Oracle to support much more memory!
For example I work on Sun Solaris (32 bit) and use 6Gb of memory after relinking without any problem!

Best regards!
Yaroslav.

>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 Tue Jul 24 2001 - 01:04:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US