Re: swap/memory ratio



Papa Piquillo wrote:
I apologize for the lack of information.
The os version is hp-ux 11.11 and the rdbms is oracle 9.2.0.6
The installation docs give requirements for Oracle to be installed not
for the production environment.
I know that this requirements are imposible to estimate without the
information of the number of concurrent and the activity of them in
the database.
I have estimated that the amount of memory that Oracle will need is 4
Gb (including sga and user processes).
I will have 2 Gb RAM and let's say 6 Gb of swap.
Is this appropiated for an OLTP system?

As good a starting point as any.

There is no way to predict, in advance, a correct value. Start there
and then expect to tune the system based on metrics.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
.



Relevant Pages

  • Re: swap/memory ratio
    ... The os version is hp-ux 11.11 and the rdbms is oracle 9.2.0.6 ... The installation docs give requirements for Oracle to be installed not ...
    (comp.databases.oracle.misc)
  • Re: oracle 9i installation on Fedora core4
    ... I need a document for installation of Oracle 9i on Fedora Core4, ... My assumption is you mean something other than the standard ...
    (comp.databases.oracle.server)
  • OT: How I learned to stop worrying and love the RDBMS
    ... After several years of working with Oracle doing migrations from MPE/IMAGE ... selecting an RDBMS as a migration target from IMAGE ... The capabilities afforded by a proper RDBMS are astounding and are growing ...
    (comp.sys.hp.mpe)
  • Re: OT: How I learned to stop worrying and love the RDBMS
    ... Denys, I tend to use MySQL mostly because my data requirements are typically modest for what I do for myself or most of my clients, but I did spend a fair bit of time with PostgreSQL some years ago and was very amazed at how well it scaled, even in direct competition with Oracle. ... selecting an RDBMS as a migration target from IMAGE ... The capabilities afforded by a proper RDBMS are astounding and are growing ... To join/leave the list, search archives, change list settings, * ...
    (comp.sys.hp.mpe)
  • Re: OT: How I learned to stop worrying and love the RDBMS
    ... ORACLE and SQL Server, and I can tell you this, the current RDBMS ... The capabilities afforded by a proper RDBMS are astounding and are ...
    (comp.sys.hp.mpe)