Tuesday, October 14, 2008

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, BZIP2 or ZLIB)

ALGORITHM_DESCRIPTION

VARCHAR2(64)

Description of the algorithm

ALGORITHM_COMPATIBILITY

VARCHAR2(18)

The required database compatibility level in order for the algorithm to work (for example, 11.0.0 for ZLIB)

DATABASE_COMPATIBILITY

VARCHAR2(18)

Current database compatibility

IS_VALID

VARCHAR2(3)

Whether or not the algorithm is valid with regard to the compatibility setting. Value is YES if ALGORITHM_COMPATIBILITY<=DATABASE_COMPATIBILITY.

IS_DEFAULT

VARCHAR2(3)

Whether or not this is the default algorithm

Oracle data dictionary views

Oracle dynamic performance views

No comments:

Post a Comment