3 Replies Latest reply: Mar 1, 2013 9:40 PM by Maran Viswarayar RSS

    Server Memory Issue

    Maran Viswarayar
      We have sun t4-2 Box (ldmo) with 120GB of memory allocated with oracle 11Gr 2

      the database runs at 20GB...as more users started using the system, we had shared pool memory issues so we decided to increase the mmemopry to 30GB..

      We set the mermoy to 30GB and started the DB, it hanged...it becamed very very slow....we cant even ls -l the directory 10-15 secs...we had no choice we reverted to 20Gb and it worked but the oracle started to exceed 20Gb it hanged again...then we decided to move to Node 2..this is a rac one node system- so we moved node2 whihc is running fine without any issues

      prtdiag -v shows 120GB ..now the system is free as we have moved the Instance to another Node.

      the server is idle but VM stat only show 32GB free and i suspect this 32 GB limit capping is set...

      $ vmstat 5 10
       kthr      memory            page            disk          faults      cpu
       r b w   swap  free  re  mf pi po fr de sr vc vc vc vc   in   sy   cs us sy id
       0 1 0 16567304 18737656 146 306 0 0 0 0 0  8  3 305 273 36069 93259 46870 2 1 96
       0 0 0 51219352 33918192 5 10 0 0  0  0  0  0  3  0  0 3364 10569 3560 0  0 100
       0 0 0 51218648 33917488 0 1 0  0  0  0  0  0  3  0  0 3264 7288 3441  0  0 100
       0 0 0 51218656 33917496 461 892 0 0 0 0 0 14  3  0  0 3886 11453 4528 0  0 100
       0 0 0 51218696 33917536 61 104 0 0 0 0  0  0  3  0  0 3755 8850 4203  0  0 100
       0 0 0 51218696 33917536 0 0 0  0  0  0  0  0  3  0  0 3611 9143 4021  0  0 100
       0 0 0 51218696 33917536 0 0 0  0  0  0  0  4  3  0  0 3422 7272 3629  0  0 100
       0 0 0 51218696 33917536 0 0 0  0  0  0  0  0  3  0  0 3348 8512 3524  0  0 100
       0 0 0 51218696 33917536 131 135 0 0 0 0 0  0  3  0  0 3475 7793 3745  0  0 100
       0 0 0 51218704 33917544 472 774 0 0 0 0 0 12  3  0  0 3983 10952 4716 0  0 100
      SGPA042A@ERPLNDB$
      Edited by: Maran Viswarayar on Mar 1, 2013 8:59 PM
        • 1. Re: Server Memory Issue
          rukbat
          Moderator Comment and Action:
          This doesn't appear to be a hardware issue as you have inferred there are no hardware errors in the computer system. Same as with regards to your Solaris OS that is on that box, as you haven't reported any fundamental OS issues.

          This initially appears to be an issue with how your application is using (or not correctly using) the available RAM that is in that system. There may be some accidental typo in the application's configuration.

          Thus I am moving your question from the Solaris 10 forum to the RAC forum to hopefully have it be a bit closer to the topics discussed there.

          If it is finally determined to be a hardware or OS issue, then others can move it to yet another forum.
          (I won't be monitoring the thread.)


          Edit:
          I have also deleted your duplicate post that you placed in the Database General Questions forum.

          Edited by: rukbat on Mar 1, 2013 8:13 AM
          • 2. Re: Server Memory Issue
            Maran Viswarayar
            vmstat gives only 33GB memory.... we are running a database and instance has been moved to node 2 and runinng without any issues


            its Solaris Hypervisor- 1 host and 1 guest on 1st t42-2, 1 host and 2 guest on 2nd t4-2
            • 3. Re: Server Memory Issue
              Maran Viswarayar
              Below is the memstat where ZFS file data is using around 80 GB on the system, we have only only ASM instance running....Do i need to limi the ARC size?
              root@SGPA042A #  echo "::memstat"|mdb -k
              Page Summary                Pages                MB  %Tot
              ------------     ----------------  ----------------  ----
              Kernel                     671257              5244    4%
              ZFS File Data            10238633             79989   66%
              Anon                       261100              2039    2%
              Exec and libs               50877               397    0%
              Page cache                  17575               137    0%
              Free (cachelist)            51475               402    0%
              Free (freelist)           4165696             32544   27%
              
              Total                    15456613            120754
              Physical                 15439572            120621