SELECT
  algorithm_name,                          -- ALGORITHM_NAME VARCHAR2(64)
  initial_release,                         -- INITIAL_RELEASE VARCHAR2(18)
  terminal_release,                        -- TERMINAL_RELEASE VARCHAR2(18)
  algorithm_description,                   -- ALGORITHM_DESCRIPTION VARCHAR2(64)
  algorithm_compatibility,                 -- ALGORITHM_COMPATIBILITY VARCHAR2(18)
  is_valid,                                -- IS_VALID VARCHAR2(3)
  requires_aco                             -- REQUIRES_ACO VARCHAR2(3)
FROM
  gv$rman_compression_algorithm
WHERE
  inst_id = USERENV('Instance')