Re: What is in a pipe?

From: joel garry <joel-garry_at_home.com>
Date: Fri, 30 Jan 2009 08:35:13 -0800 (PST)
Message-ID: <6dda543f-8ac5-43d9-afc8-9ae6c0803f17_at_n33g2000pri.googlegroups.com>

On Jan 30, 3:54 am, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk> wrote:
> "Geoff May" <Do..._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/

That one is just awesome.

It does beg Ed's point about timeliness. I only say anything because of Geoff's emphasis on packing/repacking implies a high level of consistency, while the cool script would be sampling inconsistently, if I understand this right. But the requirement of figuring out what is overloading the pipes and why may be satisfied. This depends on refining the requirement. If it's just going to be used by a couple of guys, ok, but if it's being put on top of a product or starts blindly propagating through the universe it's likely to lose the blog context...

jg

--
_at_home.com is bogus.
28 year old single mom living in 2 bedroom apartment with her mother
has fertility treatments, octuplets.  Last year they lost everything
in bankruptcy, now Grandpa is going back to Iraq...

Received on Fri Jan 30 2009 - 10:35:13 CST