No. You have to read the pipe but that will actually take the message off
the pipe...
--
Gerrit-Jan Linker
SQL*XL: addin for Excel for easy access to Oracle databases
http://www.oraxcel.com
"bhogak" <bhogak_at_yahoo.com> wrote in message
news:9hu605$a8s$1_at_bob.news.rcn.net...
> Is there any way to know if an Oracle pipe has a message in it? The view
> v$db_pipes does have a pipe_size column but even after unpacking all the
> messages, the size doesn't immediately change in that view. Also, I think
> pipes mantain an "overhead" size and its not same for different pipes.
>
> We would like to do a clean database shutdown and want to make sure that
> there are no messages in any of our pipes.
>
> Thanks.
> bhogak.
>
>
Received on Sun Jul 08 2001 - 11:33:24 CDT
