Frederic, Please ask the PRO*C programmer if they are making any use of the C "malloc()" library at all in that program, or anything similar. If so, then the most likely problem is that they are not properly freeing memory after grabbing some more. This is a very common mistake when writing daemons in "C". Bad habits that were disguised when writing short-running batch programs become evident after writing long-lived daemon processes. It's like camping in the back country -- you have to carry out everything you bring in, which isn't like camping in a campground...
Of course, it is possible that something inside the Oracle-managed portion of PRO*C is doing the same, but if there is any presence of "malloc()" in their code, it is almost certainly self-inflicted. It is the first thing to check before blaming PRO*C or Oracle... Hope this helps... -Tim ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, June 03, 2002 5:08 AM > Hi, > > OS : AIX 4.3.3.0 > RDBMS : 8.0.6.2.0 > > We have a Unix daemon write in Pro*C that wake up every X minutes (I think > it's about 1) > to look at one table on an AS400 via dblinks and transparent gateway from > the AIX server. > > Our problem is that the shadow process constantly increase his consomation > of memory > when we look at via the "ps" command at the os level. > Our only solution is to stop/start the daemon when it has reached a certain > level > of memory and before the server could not do anything :-). > > Anyone has an idea ? Could you resfresh my memory of what is in the memory > of a shadow process ? > Has we have others choice for isolating the problem ? > > Thanks. > > Frédéric Major > DBA, Oracle 8i OCP. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?Q?Fr=E9d=E9ric_MAJOR?= > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).