RE: Problem on shadow process

>
>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.
>

Packaged variables mentioned in another thread. The problem is likely to come from packaged procedures. Check that you do not use PL/SQL tables which you would never empty. FYI there is in the dbms_utility package a number of routines for relasing memory but they come with a number of health warnings. Do not jump on them before having performed a thorough PL/SQL code review.

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  INET: sfaroult_at_oriolecorp.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).