Re: What is in a pipe?

From: ddf <oratune_at_msn.com>
Date: Thu, 29 Jan 2009 08:11:34 -0800 (PST)
Message-ID: <f56fe67b-2e94-4df2-835d-b53254a6b432_at_d36g2000prf.googlegroups.com>



On Jan 29, 9:49 am, Ed Prochak <edproc..._at_gmail.com> wrote:
> On Jan 28, 4:10 pm, Geoff May <Do..._at_Spam.Me> wrote:
>
>
>
>
>
> > Hi all,
>
> > I'm trying to work out how many messages are queued in a pipe and how
> > long said messages are. Anyone got any ideas?
>
> > So far, the best I can come up with is something silly like receiving
> > DBMS_PIPE messages, unpacking them, counting and adding lengths and then
> > repacking and requeuing the messages.
>
> > What I would like is something like this:
>
> > select * from DBA_ALL_ABOUT_PIPES;
>
> > And DBA_ALL_ABOUT_PIPES has the name, type of pipe (public or private),
> > size, number of queued messages and length of messages.
>
> > Anyone have any ideas?
>
> > Cheers
>
> > Geoff
>
> There is not a general way to do this, even in the UNIX world where
> pipes are used extensively.
> One reason for this is about the time you get an answer, the
> information is likely wrong.
>
> So why would you want this?- Hide quoted text -
>
> - Show quoted text -

Maybe he's checking for leaks ... :D

David Fitzjarrell Received on Thu Jan 29 2009 - 10:11:34 CST

Original text of this message