select algorithm_id, -- ALGORITHM_ID NUMBER algorithm_name, -- ALGORITHM_NAME VARCHAR2(64) algorithm_description, -- ALGORITHM_DESCRIPTION VARCHAR2(64) is_default, -- IS_DEFAULT VARCHAR2(3) restore_only -- RESTORE_ONLY VARCHAR2(3) from gv$rman_encryption_algorithms where inst_id = USERENV('Instance')