After increasing the memory
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: After increasing the memory

  1. #1
    Join Date
    Oct 2003
    Posts
    4

    After increasing the memory

    Hi All,

    We are planning to increase the server memory to increase the database performance. Could you please advise me what are the things to be taken care after we physically adding the memory.

    Oracle 8i database is running on Linux machine.

    Please get back to me if you need any other information.

    Thanks for your time and help.

    Regards,
    Ganesh
    Ganesh

  2. #2
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    depends on many things , few of them are

    1. using shared or dedicated server ?
    2. No of users accessing db .
    3. check various wait events .decide whether more memory realy reqd or not because if u are unnecessary increasing memory for few like shared_pool may cause performance problem.

  3. #3
    Join Date
    Oct 2003
    Posts
    4
    Originally posted by mdash
    depends on many things , few of them are

    1. using shared or dedicated server ?
    2. No of users accessing db .
    3. check various wait events .decide whether more memory realy reqd or not because if u are unnecessary increasing memory for few like shared_pool may cause performance problem.
    Thanks for your reply.
    The database is very small and used for an internet application.
    The database size is less than 500 M and the current SGA is 90 M.
    Number of users accessing the application in peak times is 200 to 300.

    I don't have enough hands-on DBA experience but have been doing
    bit and pieces of work as and when required. Please point me the
    direction where I can get document for "checking the wait events".
    Also please let me know the parameters to increase the size.

    Once again thanks for your help.
    Ganesh

  4. #4
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    Hello,

    I'm afraid that you're installing extra memory where it probably isn't required.

    First determine if Oracle needs more memory.

    How? Run a statspack (or "Oracle Expert" if you have it installed)

    Install statspack by running script "SPCREATE.SQL", login afterwards as user "perfstat", take a snapshot with "statspack.snap;", wait a while, again take a snapshot. Run script "SPREPORT" to display the results. (And while you're waiting... RTFM )

    Anyways: If the reports shows there is 'free memory' on different memory structures, then you can keep your money in your pocket.

    HTH,
    Erik
    Last edited by efrijters; 10-07-2003 at 11:44 AM.
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

  5. #5
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684

    Re: After increasing the memory

    Originally posted by agganesh
    We are planning to increase the server memory to increase the database performance. Could you please advise me what are the things to be taken care after we physically adding the memory.
    Oracle 8i database is running on Linux machine.
    If you install big memory support on Linux, you'll have to recompile oracle to be able to allocate more memory, otherwise you'll not be able to allocate morte then 750M for your SGA.

    Relink oracle with the following options:
    In $ORACLE_HOME/rdbms/lib, run
    # genksms -s 0x30000000 > ksms.s
    # make -f ins_rdbms.mk ksms.o
    # make -f ins_rdbms.mk ioracle

    If you take a look this link, you'll see value 0x12000000 - this value did not work with me, I used '0x30000000'

    http://otn.oracle.com/tech/linux/pdf...2_accepted.pdf
    Best wishes!
    Dmitri

  6. #6
    Join Date
    Oct 2003
    Posts
    4
    Thanks Erik & Dmitri for your replies.
    I will try and run the scripts as Erik suggested.
    If I find the extra memore is really required,
    I will then add it and follow the Dmitri's solution.
    Ganesh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width