V$DB_PIPES definition in Oracle Database 11.2
V$DB_PIPES

select
  OWNERID,                                 -- OWNERID NUMBER
  NAME,                                    -- NAME VARCHAR2(1000)
  TYPE,                                    -- TYPE VARCHAR2(7)
  PIPE_SIZE                                -- PIPE_SIZE NUMBER
from
  GV$DB_PIPES
where
  inst_id = USERENV('Instance')

home |  up