DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to find out free memory ???

  1. #1
    Join Date
    Nov 2000
    Posts
    79
    Hi everyone,

    I want to increase the db_block_buffers. But when i see the free memory through sar -r unix command it just shows the blocks equal to 3meg.

    The size of the RAM on the box is 2.5G and the SGA size is 1G. Is unix system using more than 1 G of RAM ?.

    I would really appreciate your help.

    Thanks,

    gtm


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Which Unix? On Solaris, the command to find physical memory is prtconf | grep Memory

    Depending on the number of users, I like to have the SGA about 50-60% of Physical RAM.
    Jeff Hunter

  3. #3
    Join Date
    Nov 2000
    Posts
    79
    Thanks for your reply. Its solaris.

    The physical memory :

    prtconf |grep memory = 2560 M



    $ sar -r 5 4

    SunOS marge 5.7 Generic_106541-15 sun4u 06/22/01

    16:15:13 freemem freeswap

    16:15:18 6664 9567952
    16:15:23 6661 9567952
    16:15:28 6658 9567952
    16:15:33 6652 9567952

    Average 6659 9567952


    free memory : 6659 blocks of 512 bytes = 3.1M ???


    Thanks
    gtm

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    freemem reports the number of PAGES of free memory, not of disk blocks.

    freeswap reports the number of BLOCKS free (512 bytes).

    If you have a page size of 2k (the solaris default, I think), then you have (6659 * (2*1024))/(1024*1024) or 13M free.
    Jeff Hunter

  5. #5
    Join Date
    Nov 2000
    Posts
    79
    Thank you Jeff for the reply.

    I still have confusion, the SGA size is 1.1 G, then rest of 1.4 G is used by Unix ??.

    The freemem report is valid ?.

    Why is only 13M left ??

    Your help is really appreciated.

    Thanks,

    gtm

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