>
>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: [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).
