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