This discussion is archived
1 Reply Latest reply: Sep 18, 2012 4:57 AM by orafad RSS

very large apache processes with php+oci8 on S11

929847 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points