Re: Solaris/Oracle Sizing Question

On 8 May 2003 15:01:27 -0700, yamahasw40_at_latinmail.com wrote:
>I think this is a dumb question, but its for Management so bear with
>me.
>...
>I have spent the last couple of hours trolling sun.com and oracle.com
>looking for an "Oracle on Sun" sizing calculator. Does such a beast
>exist and if so, can you please throw me a link? Note that this has
>to come from either Sun or Oracle. Management won't believe anything
>that isn't straight from the mouth a vendor (God help me).

Then tell em "go pay oracle to fly someone down and tell you exactly what I'm telling you now"

>My client has a client who has a 16 USparc-III domain on a Sun 12K
>with 20GB of RAM. They are running "Oracle" but I can't get any more
>information on that. (I am assuming that its a DB, probably 8i). The
>project manager wants a magic document that will say "for X CPUs you
>need Y GB of RAM". I reckon this doesn't exist. (Even though all the
>standard Sun Configs are 2GB/CPU, they don't seem to actually mention
>this as a minimum).

That is a completely wrong question. A more correct question is, What are the values/ratio for D and Y, for the equasion, "For D amount of DATABASE DATA, you need Y GB of RAM"

For perfect, guaranteed max use of CPUs performance, you need approximately   Y = D *2

For durn good performance, you need approximately Y = D

For good performance, you need approximately Y = W * 2, where W = the approximate amount of unique data bytes used by the system

    over the course of 1 hour, or 1 day, or some interesting unit of time     dependant on the bandwidth of your disks and the minimum amount of latency     you are willing to put up with.

It is *2, because you also need space to hold the index information

-- 
  http://www.blastwave.org/ for solaris pre-packaged binaries with pkg-get
    Organized by the author of pkg-get
[Trim the no-bots from my address to reply to me by email!]
         S.1618 http://thomas.loc.gov/cgi-bin/bdquery/z?d105:SN01618:_at_@@D
                            http://www.spamlaws.com/state/ca1.html