Results 1 to 6 of 6

Thread: Oracle

  1. #1
    Join Date
    Dec 2009
    Posts
    12

    Unanswered: Oracle

    Hi All,

    We installed oracle 10g in HP server with 40 GB of memory. But always the memory utilization shown as 100% or 99%. To avoid this we added 20Gb more memory but still memory utilization is high. Could you pls advise how to solve this issue?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Could you pls advise how to solve this issue?
    There is NO issue.
    This is expected & desired results.
    Please explain in DETAIL the benefit of having RAM that is not used.
    Why would you want, expected or desire to have RAM in a system that nobody or nothing ever uses?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2009
    Posts
    12
    hey thanks for your reply.

    > Please explain in DETAIL the benefit of having RAM that is not used.
    Obviously no usage. But we cannt predict whether we are running with enough memory or not.

    >Why would you want, expected or desire to have RAM in a system that nobody or nothing ever uses?
    The primary reason is, within end of year this year we need to come to conclusion whether we are running with enough memory or not (for current system load). Based on that we need to do calculation and submit proposal (to purchase additioal resources) in advance for coming year's load.

    But its hard to justify how much memory is effectively utilized by Oracle. It seems to be it simply occupies all RAM. So we cannt come to conculsion whether memory is utilized or unutilized.

    Thanks

  4. #4
    Join Date
    Nov 2003
    Posts
    2,932
    Provided Answers: 12
    Quote Originally Posted by balaparthibanmdu View Post
    It seems to be it simply occupies all RAM.
    There is an initialization parameter that tells Oracle how much of the memory to use. Maybe that's set to 100% in your installation.
    I don't recall the name of the parameter, but you'll find it in the manual.

  5. #5
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Did you say target?

    The parameter shammat refers to is: SGA_TARGET which specifies the total size of all SGA components.

    Another parameter to consider is: PGA_AGGREGATE_TARGET which specifies the target aggregate PGA memory available to all server processes attached to the instance.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >But we cannt predict whether we are running with enough memory or not.
    What you see & report is normal for any flavor of *nix.
    Any RAM that Oracle does not consume, then the OS will use it a file system cache.
    In order to determine, if the system has not enough RAM, then look at swap rate.

    Code:
    oracle@bcm-laptop:~$ vmstat 3 3
    procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu----
     r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy id wa
     0  0 383560  28924  32204 428936    1    1     9    21   44   28 16 10 73  0
     1  0 383560  28860  32212 428896    0    0     0    20 1071 1214 16  5 79  0
     0  0 383560  28860  32212 428896    0    0     0    16 1110 1388 11  4 85  0
    when si (swapin) & so (swapout) values are near zero, then RAM is OK!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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