Re: dbms_pipe: what would cause a timeout?

From: Bradd Piontek <>
Date: Tue, 7 Oct 2008 15:28:53 -0500
Message-ID: <>

  Are you positive it is a timeout? there are only a few statuses that come back from the send message. (0,1,2,3, I believe). It could be that the pipe is full (select ownerid,name,type,pipe_size from v$db_pipes)

Bradd Piontek
  "Next to doing a good job yourself,

        the greatest joy is in having someone
        else do a first-class job under your
  • William Feather

On Tue, Oct 7, 2008 at 2:39 PM, Charles Schultz <>wrote:

> Good day, list,
> What would cause a call to dbms_pipe.send_message to timeout?
> We have an ERP-delivered procedure that "pings" a few public ERP pipes in
> Oracle running on Solaris 8. I tried tracing (event 10046) but
> did not find much, and trying to drill down via OEM was difficult at best.
> Could be me. =) I am trying to understand what would cause a timeout,
> whether it be a database problem, and if so, where. Not much documentation
> about pipe-specific problems out there in the wild.
> --
> Charles Schultz

Received on Tue Oct 07 2008 - 15:28:53 CDT

Original text of this message