Re: Problem on shadow process

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" <ORACLE-L_at_fatcity.com> 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: frederic.major_at_sydel.fr
>
> 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: ListGuru_at_fatcity.com (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: Tim_at_SageLogix.com

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: ListGuru_at_fatcity.com (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).