Re: What is in a pipe?
Date: Fri, 30 Jan 2009 11:54:30 -0000
"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?
This might help:
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Author: Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.htmlReceived on Fri Jan 30 2009 - 05:54:30 CST