Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_pipe: where can I see the current Pipes
Jurgen,
In future, you can search for the view names as follows -
select * from all_objects where object_name like '%PIPES%'; Hope this helps....
"Jürgen Pelz" wrote:
> Thanks.
> Jürgen.
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> schrieb im Newsbeitrag
> news:aombak$72h$1$8302bc10_at_news.demon.co.uk...
> >
> > 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)
> > >
> > >
> >
> >
-- Chandra Mohan Support Engineer, Emea Tools (Developer) Team, Oracle India Private Ltd.Received on Fri Oct 18 2002 - 04:58:05 CDT