Re: dbms_pipe: what would cause a timeout?
Date: Tue, 7 Oct 2008 15:28:53 -0500
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)
"Next to doing a good job yourself,
the greatest joy is in having someone else do a first-class job under your direction."
- William Feather
On Tue, Oct 7, 2008 at 2:39 PM, Charles Schultz <sacrophyte_at_gmail.com>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 10.2.0.3 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