Tablespace encryption is very important database security feature where data at rest is encrypted for protection against any attempt of physical access to copy data file levels. Of course Oracle cloud provides security protection and encrypts tablespaces. In Oracle 21c a new security parameter feature called “ Default Tablespace Encryption Algorithm” this parameter will set the default/required encryption algorithm for newly created tablespaces…..let us briefly explore it:

The following query will list encrypted tablespaces:

SQL> select * from v$encrypted_tablespaces;

The following is the new parameter and its default value

SQL> SHOW PARAMETER TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM

its worth stating that in Oracle ATP you can’t execute create tablespace sql command: https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/appendix-restrictions-sql.html#GUID-791E7112-07F7-46F0-BD81-777C8FAD83A0