Re: dbms_pipe: where can I see the current Pipes

There's a v$ with PIPE in its name - possibly v$db_pipes

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 7/9   (Detroit)
____USA__________November 19/21 (Dallas)
____England______November 12/14

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Jürgen Pelz wrote in message
<3daea599$0$183$4d4ebb8e_at_read.news.de.uu.net>...


>Hello,

>I like to see, which pipes (created with dbms_pipe.send_message) are

>existing and which parameter they have (maxpipesize, inserted

messages,


>...). I cannot find any way. In this case we are running Oracle DBMS

Server


>7.1.x - in other systems we run oracle 8.1.7. Is there anybody who

can help?


>Thanks,

>Jürgen Pelz - pelz.j_at_zdf.de - ZDF (mit dem Zweiten sieht man besser)

>

>