Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HELP AGAIN: Oracle WEB SERVER (OWS 3.x) exhausting all System Memory !

HELP AGAIN: Oracle WEB SERVER (OWS 3.x) exhausting all System Memory !

From: The man from the great white north <anti-spam-gdallair_at_geocities.com>
Date: Wed, 23 Sep 1998 13:50:15 GMT
Message-ID: <3608fc12.4200159@news.risq.qc.ca>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US