Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Query v$db_pipes

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