select
CONF#, -- CONF# NUMBER
NAME, -- NAME VARCHAR2(65)
VALUE -- VALUE VARCHAR2(1025)
from
GV$RMAN_CONFIGURATION
where
inst_id = USERENV('Instance')