Re: What is in a pipe?

From: joel garry <joel-garry_at_home.com>
Date: Thu, 29 Jan 2009 10:22:33 -0800 (PST)
Message-ID: <d6adcf7c-f178-4427-a3ed-fd5a5b374d91_at_g39g2000pri.googlegroups.com>



On Jan 29, 8:11 am, ddf <orat..._at_msn.com> wrote:
> 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

Or invasive root... :-D

jg

--
_at_home.com is bogus.
I once rehabbed a house that had been vacant a while.  The sewer
worked fine for a couple of weeks.  Sewer guy told me old dried sludge
had taken that long to absorb water and expand.
Received on Thu Jan 29 2009 - 12:22:33 CST

Original text of this message