Results 1 to 3 of 3

Thread: RAM Usage

  1. #1
    Join Date
    Nov 2003
    Location
    Rotterdam, Netherlands
    Posts
    127

    Unanswered: RAM Usage

    Hi,
    We have 1GB of RAM on our Server & are running oracle8.1 server on it..... and we want to check if we need to upgrade the ram,

    How can we check if there is a contention in RAM or Performance is LOW due to lack of RAM Space?

    Thanks and Regards

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    This is something for the operating system administrator to check. You can not check this from within Oracle. You might have 99.9% cache hits, but this does not tell you if the cache hits were in memory or on disk? If you do not have enough RAM, then your SGA will be paged or swapped to disk, and cache hits will occur on disk. This is why you cannot check from within Oracle.

    On Windows, launch Task Manager (Ctl-Shift-Esc) and look at the "Performance" tab, and specifically in the box labeled "Physical Memory". In this box, find the line "Total" and write down the number. Now, look at the bottom right corner of Task Manager where it says "Mem Usage". There are two numbers, write down the first number only. (Mem usage has a second value that includes your RAM PLUS pagefile, so ignore that number for now.) The second number you wrote down should be 50% of the first number you wrote down. If it is higher, then add more memory. Otherwise, anytime the memory usage is >50% Windows will page more agressively and your SGA performance will suffer.

    On Unix, the steps are different, but you can use a bit more memory. You want to keep the amount of memory used < 60% RAM.

    On Windows 2000 Server, you can install up to 4 GB RAM. If your operating system and application processes together use more than 2 GB RAM, then you will find Windows begins to page blocks from RAM to disk more agressively, even if no one is using your server.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

  3. #3
    Join Date
    Oct 2003
    Posts
    706

    Thumbs up

    It's a good rule of thumb to install as much RAM as you are able, simply because it's the fastest storage-device out there. If RAM is available, the operating system will use it. Generous space allocations can be given to things like Oracle.

    The thing to watch is not "how much RAM is being used," because the OS will use as much RAM as it can. So, for that matter, will Oracle, even though its memory is virtual.

    Instead, Watch for delays. Watch for situations where the Oracle daemon is being put into wait-states due to operating system page-I/O waits: "thrashing." Watch for resource-shortages that are actually forcing things to slow down. "It's only a problem when it presents a problem."
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

Posting Permissions

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