Re: What is in a pipe?

From: Jonathan Lewis <>
Date: Fri, 30 Jan 2009 11:54:30 -0000
Message-ID: <>

"Geoff May" <DoNot_at_Spam.Me> wrote in message
> 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

This might help:


Jonathan Lewis

Author: Cost Based Oracle: Fundamentals

The Co-operative Oracle Users' FAQ
Received on Fri Jan 30 2009 - 05:54:30 CST

Original text of this message