GV$DB_PIPES

select
inst_id,                 -- INST_ID NUMBER
decode                   -- OWNERID NUMBER
  (kglobt00, 1, kglobt17, null),
kglnaobj,                -- NAME VARCHAR2(1000)
decode                   -- TYPE VARCHAR2(7)
  (kglobt00, 1, 'PRIVATE', 'PUBLIC'),
kglobhs0+kglobhs1+kglobhs2+kglobhs3+kglobhs4+kglobhs5+kglobhs6 -- PIPE_SIZE NUMBER
  
from
x$kglob 
where
kglhdnsp=7 and kglobsta != 0
home |  up  |  mailbox