1 Reply Latest reply: Sep 18, 2012 6:57 AM by orafad RSS

    very large apache processes with php+oci8 on S11

    929847
      Hello,

      I was redirected here from oracle php forum. I have problem with huge memory consumption by apache processes after upgrade.
      The previous system was Solaris 10 x86_64, php 5.3.8 compiled with instant client 10.2 (32-bit oracle basic, downloaded from oracle.com).
      Now I have Solaris 11 x86_64 and instant client 11.2 directly from IPS repository (developer/solarisstudio-123/oic), php 5.3.13 (also 32-bit).

      The problem is that the apache memory consumption has dramatically increased from average 25-35MB RSS to 80-110MB RSS per apache process.

      I'm posting "pmap -x" output before and after the upgrade (displaying only lines above 1500KB):
      BEFORE:
      Address Kbytes RSS Anon Locked Mode Mapped File
      ...
      E9830000 1772 144 - - r-x-- cs_CZ.UTF-8.so.3
      FD600000 1844 700 - - r-x-- libicui18n.so.48.0
      FC600000 8704 3496 - - r-x-- libphp5.so.5.3.8
      FA600000 12268 4096 - - r-x-- libclntsh.so.10.1
      080B9000 14876 14104 12516 - rwx-- [ heap ]
      FB400000 17764 140 - - r-x-- libicudata.so.48.0
      F6200000 65536 - - - rw-s- [ anon ]
      E9A00000 70972 780 - - r-x-- libociei.so
      EE000000 131072 7628 - - rw-s- [ anon ]
      ---
      total Kb 348452 42648 13268 -

      AFTER:
      Address Kbytes RSS Anon Locked Mode Mapped File
      ...
      FEDF0000 1352 852 - - r-x-- libc_hwcap2.so.1
      FB800000 1460 764 - - r-x-- libmysqlclient.so.16.0.0
      FE6A0000 1816 76 - - r-x-- libnss3.so
      FBC00000 2124 2100 - - r-x-- mbstring.so
      FE000000 2276 2136 - - r-x-- libxml2.so.2
      F6400000 2324 2116 - - r-x-- libnnz11.so
      FA600000 7516 6456 - - r-x-- libphp5.so
      080D8000 30604 28884 26760 - rw--- [ heap ]
      F6800000 38160 35076 - - r-x-- libclntsh.so.11.1
      EF400000 113100 16544 - - r-x-- libociei.so
      ---
      total Kb 220040 106480 27404 -

      My question is: is this normal? Does the oracle instant client always consume that much memory? Or is there any tuning possibility to reduce used RAM?
      The process memory (100MB+) is allocated after first oracle connect.
      There's no shared memory in zone displayed via "ipcs -ma".

      Thank you for your help.

      Jan
        • 1. Re: very large apache processes with php+oci8 on S11
          orafad
          Is there a business problem related to this, or could you just buy another 8 GB memory (which is extremely low cost nowadays)?

          Also, in the latter case the total committed address space is smaller, which, when added up, might explain the higher cached amount -- since more real mem available, maybe with some better performance to add.