Skip to Content
author's profile photo Former Member
Former Member

when adding RAM to a UNIX system in terms of settings (parameters, oracle

Hello

What has to be done when adding RAM to a UNIX system in terms of settings (parameters, oracle parameters...).

We are using HP-unix(if this is of any importacy) on a cluster system(DB and application server) with oracle as database

Thank you in advance

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 03, 2008 at 05:46 AM

    Thx Marcus.

    What about SAP parameters?. Which needs to be changed?

    (Do you agree all should be done only on Database server wher new RAM will be installed?)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 02, 2008 at 11:09 PM

    Yes Marcus (sorry I did not mentioned).

    The system (espetialy database ) is swappingv(therefore additional RAM)

    . Can you let me know which SAP and which ORACLE parameters should be increased(I gess only on RAMupgraded DB server)?

    Thank you in advance very very much

    Add a comment
    10|10000 characters needed characters exceeded

    • The system (espetialy database ) is swappingv(therefore additional RAM)

      Ok.

      . Can you let me know which SAP and which ORACLE parameters should be increased(I gess only on RAMupgraded DB server)?

      That question is not so easy to answer, as always "it depends" (I know, that´s not what you want to hear..)

      Check

      Note 789011 - FAQ: Oracle memory areas

      Note 619876 - Oracle9i: Automatic PGA Memory Management (also valid for 10g)

      Note 830576 - Parameter recommendations for Oracle 10g

      Oracle is a complex beast...

      Markus

  • Posted on Nov 01, 2008 at 07:03 AM

    To make use of the memory you have to reconfigure Oracle memory parameters and, if necessary, the SAP parameters too.

    What was the initial reason to upgrade the memory?

    Markus

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 02, 2008 at 10:35 PM

    Hello

    It is first time I am assigned to this kind of task.

    Where could I find oracle and specially SAP parameters which need to be adjusted.

    As we are using application and database server(load balancing with logon groups), we will upgrade only database server with 6-8GB of RAM (this will be done by others). Oracle version is 10.2.0.2.0, operating system is HP-UX (machines 9000/800)

    I assume also all other task will be performed on database server. So again which SAP parameters needs to be adjusted and with which ammounts

    Thank you very very much

    Add a comment
    10|10000 characters needed characters exceeded

    • > Where could I find oracle and specially SAP parameters which need to be adjusted.

      This depends on your requirements.

      > I assume also all other task will be performed on database server. So again which SAP parameters needs to be adjusted and with which ammounts

      You can either adjust the memory to the database alone, you can adjust it to SAP alone or you can share the additional memory for the database and SAP application.

      The question is: Did you have any bottlenecks that you want to solve by adding more memory?

      Markus

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.