Re: What is in a pipe?

"Geoff May" <DoNot_at_Spam.Me> wrote in message news:6ubvu7Fel2k4U1_at_mid.individual.net...
> 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:

http://jonathanlewis.wordpress.com/all-postings/

-- 
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.html