V$RMAN_ENCRYPTION_ALGORITHMS

V$RMAN_ENCRYPTION_ALGORITHMS displays supported encryption algorithms. It is used by the RMAN client to validate user-requested algorithms. This view will list AES128, AES192, and AES256 encryption algorithms for the current release. The default algorithm is AES128.

Column	Datatype	Description
ALGORITHM_ID	NUMBER	Number to identify the algorithm
ALGORITHM_NAME	VARCHAR2(64)	Name of the algorithm (for example, AES128, AES192, and AES256)
ALGORITHM_DESCRIPTION	VARCHAR2(64)	Description of the algorithm
IS_DEFAULT	VARCHAR2(3)	YES if this is the default encryption algorithm; otherwise NO.
RESTORE_ONLY	VARCHAR2(3)	NO if this algorithm can be used for backup; otherwise YES.

Note:

1.

select * from V$RMAN_ENCRYPTION_ALGORITHMS;

ALGORITHM_ID	ALGORITHM_NAME	ALGORITHM_DESCRIPTION	IS_DEFAULT	RESTORE_ONLY
1	AES128	AES 128-bit key	YES	NO
2	AES192	AES 192-bit key	NO	NO
3	AES256	AES 256-bit key	NO	NO

Oracle data dictionary views

Oracle dynamic performance views