I have a pipe that seems to be set up fine, but it just isn't working.
I ran
select system$pipe_status('"MY_DB"."MY_SCHEMA".MY_PIPE_NAME');
i'm getting back a growing number of numOutstandingMessagesOnChannel
Can someone please explain what that means?
Is that rows that will be processed? Do I expect this number to go down? Is there a number where it's too high?
Is there something / some way to track why/when it goes up?
The documentation says merely,
numOutstandingMessagesOnChannel
Number of messages in the queue that have been queued but not received yet.