AIX

AIX

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


#Power
#Power
 View Only

  • 1.  PO is high in VMSTAT

    Posted Tue February 28, 2012 04:10 AM

    Originally posted by: sajid1


    AIX 5.2
    EBS R12
    DB 10.2.0.4

    There are two node installations. On one node all application servers are located and another node is located only database.

    What I understand there is paging issue find below for your reference, see there PO is high what I know if po is high is indicating demand memory (please advice if I am right) so I need to increase SGA size of database correct?

    kthr memory page faults cpu
    -----------
    ------------
    r b avm fre re pi po fr sr cy in sy cs us sy id wa pc ec
    1 4 2812813 19942 0 368 495 516 1666 0 646 444 1317 2 2 75 21 0.09 4.6
    1 2 2812812 19955 0 389 527 533 1438 0 646 501 1378 2 3 73 22 0.10 5.0
    1 2 2812812 19837 0 445 553 581 1406 0 638 491 1499 2 3 73 22 0.10 5.0
    1 2 2812811 19838 0 366 502 548 2971 0 657 417 1325 2 2 73 23 0.09 4.4
    2 3 2812811 19838 0 375 517 529 2487 0 651 670 1359 2 2 73 23 0.09 4.6
    1 3 2812811 19914 0 331 446 452 1337 0 644 319 1266 2 2 73 23 0.09 4.3
    1 3 2812811 19949 0 379 501 516 1310 0 646 417 1365 2 2 74 22 0.09 4.4
    1 2 2812810 19897 0 372 423 452 1683 0 642 442 1335 2 2 74 22 0.08 4.1
    1 8 2812813 20162 0 375 558 581 1549 0 735 935 1296 2 3 73 22 0.11 5.6
    2 6 2812812 19877 0 484 441 452 1169 0 713 489 1504 2 2 74 23 0.08 4.1

    ---Memory demands means what, is it RAM increasing or SGA increasing?

    Database RAM size is 5 GB in which 3GB for SGA and for PGA is 1GB, In this case we cannot increase the size of SGA because 1GB have to keep for OS processing correct?

    On Application node RAM size is 5GB My question is here for application server do 5GB RAM is enough and can I reduce it 2 GB and assign it to database node ??

    Thanks
    #AIX-Forum


  • 2.  Re: PO is high in VMSTAT

    Posted Tue February 28, 2012 10:40 AM

    Originally posted by: romeo_ninov


    Add more physical RAM or decrease SGA
    #AIX-Forum


  • 3.  Re: PO is high in VMSTAT

    Posted Tue February 28, 2012 11:05 AM

    Originally posted by: sajid1


    Thanks for responding.

    If I go with you the Paging out issue will resolve and application performance will perform well??
    #AIX-Forum


  • 4.  Re: PO is high in VMSTAT

    Posted Wed February 29, 2012 03:54 AM

    Originally posted by: romeo_ninov


    Yes, the problem is (IMHO) out of memory. And Oracle DB especially prefer to "live" in RAM
    #AIX-Forum


Related Content