| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBMS_PIPE and the shared pool
We do have one that is left there. Its the one that all other
pipes communicate with. However, the others need to be on a
session basis so we can't just leave them there. Just way to
many applications and users.
-----Original Message-----
From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
Sent: Friday, January 26, 2001 9:42 AM
To: Multiple recipients of list ORACLE-L
Subject: Re:DBMS_PIPE and the shared pool
Kimberly,
I have an application that makes use of three different pipes for
communication. These are created, implicitly, and then left there forever
by
the different programs. I haven't seen any kind of problem with them. Sure
they occupy some area in the shared pool, but as a whole it's not enough to
fuss
about.
Dick Goulet
____________________Reply Separator____________________ Author: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com> Date: 1/26/2001 9:00 AM
We are having some issues here with using database pipes and having the shared pool become fragmented. The way the code is setup is that pipes get created every time the procedure is called and then removed after they are done with it. Recently activity has increased in one of the areas that these pipes are created.
We were thinking of changing the code to explicitly create the pipes but
not remove them until the user closes the application. One problem that we
foresee with this is that if a user's PC crashes this will remain in the
shared pool.
According to Oracle, pipes created in this method will remain there until
database is shutdown. It looks like even flushing the shared pool will not
help.
Does anyone have some guidelines based on past issues with using the DBMS_PIPE stuff that we could use to help us out? Changing to external procs is not really on option at the moment although its planned for later on.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kimberly Smith
INET: kimberly.smith_at_gmd.fujitsu.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).
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 Received on Fri Jan 26 2001 - 12:29:26 CST
 |
 |