V$RMAN_COMPRESSION_ALGORITHM

V$RMAN_COMPRESSION_ALGORITHM provides descriptions of supported compression algorithms. It is used by the RMAN client.

Column	Datatype	Description
`ALGORITHM_ID`	`NUMBER`	Algorithm ID
`ALGORITHM_NAME`	`VARCHAR2(64)`	Name of the algorithm (for example, `LOW`, `MEDIUM`, `DEFAULT`, or `HIGH`)
`INITIAL_RELEASE`	`VARCHAR2(18)`	First Oracle Database release when this compression algorithm was available
`TERMINAL_RELEASE`	`VARCHAR2(18)`	Last Oracle Database release that supported using this compression algorithm to create new backups. Existing backups can always be restored, even if they use a deprecated compression algorithm.
`ALGORITHM_DESCRIPTION`	`VARCHAR2(64)`	Description of the algorithm
`ALGORITHM_COMPATIBILITY`	`VARCHAR2(18)`	Required database compatibility level for the algorithm (for example, 11.2.0 for `DEFAULT`)
`IS_VALID`	`VARCHAR2(3)`	Indicates whether the algorithm is valid with regard to the compatibility setting (`YES`) or not (`NO`). The value is `YES` if `ALGORITHM_COMPATIBILITY` <= `DATABASE_COMPATIBILITY`.
`REQUIRES_ACO`	`VARCHAR2(3)`	Indicates whether the algorithm requires the Advanced Compression Option (`YES`) or not (`NO`)
`IS_DEFAULT`	`VARCHAR2(3)`	Indicates whether the algorithm is the default compression algorithm that RMAN uses to create compressed backup sets (`YES`) or not (`NO`)
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data