How to list encrypted tablespaces and columns in Oracle

List what TDE actually protects: which tablespaces are encrypted and which table columns carry column-level encryption.

-- Encrypted tablespaces
SELECT ts.name AS tablespace_name, e.encryptionalg, e.status
FROM   v$encrypted_tablespaces e
JOIN   v$tablespace ts ON ts.ts# = e.ts#
ORDER  BY ts.name;

-- Encrypted columns
SELECT owner, table_name, column_name, encryption_alg
FROM   dba_encrypted_columns
ORDER  BY owner, table_name, column_name;