Nora
Not answering your question (I can't it depends on the app and the data)
but is there a business reason you are adding instances and not schemas?
More than one instance is an overhead that needs justification.
On 6/24/05, BERNHARD Nora <nora.bernhard_at_stgkk.sozvers.at> wrote:
>
> Hello list :)
>
> I wonder if there is any possibility to calculate the estimated amount of
> RAM needed for an Oracle instance to run smoothly. To be explicit, I have a
> 2-node Oracle 10g RAC running on SuSE Linux, with 4 CPUs and 8 GB RAM each.
> There are already four instances installed each of which equally uses 2GB
> RAM. For the machines are avg. 80% idle (rather small databases, few users),
> we are thinking about adding another two instances to the RAC which have a
> total of about 200 (~130 + ~70)users together. So, can I somehow figure out
> how much the basic usage for one instance is plus a variable amount
> depending on the number of users?
>
> Any help appreciated - hints, infos, links etc.
>
> Thanks in advance!
>
> Cheers,
>
> Steiermärkische Gebietskrankenkasse
> A-8011 Graz, Josef-Pongratz-Platz 1, http://www.stgkk.at
>
> Nora Bernhard
> OE Informationstechnologie - Systemadministration
> Tel: +43 (0) 316 8035 - 1349
> Fax: +43 (0) 316 8035 - 661349
> mailto:nora.bernhard_at_stgkk.sozvers.at
>
> --
> http://www.freelists.org/webpage/oracle-l
>
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 24 2005 - 03:44:42 CDT
