SQL>
SQL> SELECT *
2 FROM v$db_pipes
3 where rownum < 50;
OWNERID
----------
NAME
--------------------------------------------------------------------------------
TYPE PIPE_SIZE
------- ----------
36
TEST 1
PRIVATE 1415
SQL>