Tablespace Encryption Elapsed Time in RAC
Hello,
I am planning to implement TDE in a production database running in RAC environment.
Post TDE implementation, I have to encrypt an existing tablespace (Size: 500 GB) having 17 datafiles.
Can someone please let me know how to estimate the total elapsed time to complete an online encryption operation on this particular tablespace (using Oracle-managed files)?
I know it depends on the various factors like size of each DB file, storage performance etc but still if there is any query to estimate before real implementation.
I will use the following SQL statement to encrypt.
alter tablespace <tablespace_name> encryption online using 'AES256' encrypt;