AIX

AIX

Connect with fellow AIX users and experts to gain knowledge, share insights, and solve problems.

 View Only

  • 1.  Why SWAP space usage is so high

    Posted Thu March 10, 2011 12:10 AM

    Originally posted by: salmanucit77


    Hi,
    I have 16G of RAM on AIX 6.1 server where i have 2 oracle 11g database running. total RAM which i allocated to oracle instences is 10.5G and total sessions which connected to both database is around 350. One session can use around 2 to 3 MB of RAM so total expected RAM allocation for total 350 sessions could be maximum 1G. So total RAM usage for Oracle should not be more than 11.5G. Now, i can see that 40% from my total 32G SWAP space is in use and i am worried that why is it like that. Why SWAP space is in use even if i have so much free RAM on my server. Any suggestions?
    Can anyone tell me some command to find out how much RAM each process is using so that i can find that which processes is consuming the most and is really sum of all processes RAM usage more than 16 G making 40% of my SWAP space to be utilized.
    Thanks

    Salman


  • 2.  Re: Why SWAP space usage is so high

    Posted Tue March 15, 2011 12:10 AM

    Originally posted by: SystemAdmin


    Hello.

    I need to see the following output:

    vmo -a

    vmstat 1 10

    lsps -a

    lsps -s

    svmon -G

    Henrique Tancredi


  • 3.  Re: Why SWAP space usage is so high

    Posted Thu March 17, 2011 07:37 AM

    Originally posted by: MatthewBourne


    Hi

    Having similar issues: DW Forum Thread

    Do you see similar kernel memory footprint? NMON is a good starting point


  • 4.  Re: Why SWAP space usage is so high

    Posted Thu March 17, 2011 07:40 AM

    Originally posted by: DjRobin69


    Speak to your DBA's, out of the box most Database Applications will grab as much of the memory as possible, to increase performance. This can be restricted within Oracle


  • 5.  Re: Why SWAP space usage is so high

    Posted Fri March 18, 2011 05:07 PM

    Originally posted by: SystemAdmin


    Well....

    My best guess is that you are using pinned memory and Oracle is not configured to use it.

    Check if you have lgpg like this on your vmo -a.

    lgpg_regions = 0

    Tancredi