Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> HELP AGAIN: Oracle WEB SERVER (OWS 3.x) exhausting all System Memory !
Anyone experienced that kind of problem or have a fix for the
following situation:
Some of our oracle server process (users connections) are growing, growing, growin and GROWING ad infinitum, eventually leading to exhaustion of all virtual memory on the machine and a system crash.
This happens with users using the oracle web server only. Is there some kind of problem with memory not being released or things like that ?
Here is a snaphot of a growing session:
At Fri Sep 18 11:21:11 EDT 1998
PID USER %CPU VSZ SZ RSS COMMAND
20802 oracle 18.7 463260 115815 434824 oracleCVC (LOCAL=NO)
VSZ=463260
At Fri Sep 18 11:39:01 EDT 1998
PID USER %CPU VSZ SZ RSS COMMAND
20802 oracle 19.9 817148 204287 449604 oracleCVC (LOCAL=NO)
VSZ=817148
...
At Fri Sep 18 12:15:41 EDT 1998
PID USER %CPU VSZ SZ RSS COMMAND
20802 oracle 20.7 1350156 337539 415880 oracleCVC (LOCAL=NO)
VSZ=1350156
Here is the list of oracle + Unix Processes at this time
Oracle + UNIX Processes:
USERNAME OSUSER SID SERIAL# CLIENT CLI PID ---------- -------- ---------- ---------- ---------- --------- SVR PID --------- ACC_MAJ_DO hbeaumon 11 502 HBEAUMON 429078277 C 7453 ACC_MAJ_DO dgingras 33 149 USAGER 429401562 C 8220 CTXSYS oracle 19 1 produc 18710 18740 CTXSYS oracle 16 9 produc 18711 18728 CTXSYS oracle 15 12 produc 18712 18736 MCARREAU oracle 14 865 produc 20784 20802 PRD_RISIC cmtrembl 24 1503 CMTREMBL 429092236 5786 PRD_VIC bclaveau 22 1533 BCLAVEAU 429096111 17641
...
Any help would be appreciated !
NOTE: To reply via e-mail, remove the 'anti-spam-' from my e-mail adress Received on Wed Sep 23 1998 - 08:50:15 CDT