AbdulWasiq

How to check if TDE or TSE is enabled in database (Doc ID 2169007.1)

TDE is encryption is table column level

TSE us encryption in table space level

To check if your table space is encrypted, run below query

sql > SELECT tablespace_name, encrypted, status FROM dba_tablespaces where tablespace_name = "<TS name>"

To check if you have encrypted columns use

sql > SELECT * FROM dba_encrypted_columns;

To check TDE is enabled on all tablespaces.