Re: What is in a pipe?

From: Ed Prochak <edprochak_at_gmail.com>
Date: Thu, 29 Jan 2009 07:49:29 -0800 (PST)
Message-ID: <0d1bccab-3582-444f-a01f-ee17b5c58cf7_at_f11g2000vbf.googlegroups.com>

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? Received on Thu Jan 29 2009 - 09:49:29 CST