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')