Re: encryption software's

Narisetty,

I think your only options for encrypting data at-rest with Standard Edition is to have your application code use either the built-in DBMS_CRYPTO package or the even-older built-in DBMS_OBFUSCATION_TOOLKIT package.  Tim Hall's oracle-base.com website has a good description of both starting HERE
<https://oracle-base.com/articles/10g/database-security-enhancements-10g#dbms_crypto>. I'm guessing that the performance impact of using either of these packages can be significant and noticeable, depending on how frequently it is used.

If you're seeking only to mask data and not encrypt it, you might consider looking at the Data Masking pack in Oracle Enterprise Manager (HERE
<https://www.oracle.com/technetwork/database/manageability/data-masking-pack-11gr2-datasheet-128617.pdf>). Masking is a slightly different use-case than encryption, and doesn't always require decryption.

Hope this helps...

Thanks!

-Tim

On 10/31/2022 5:41 PM, Vinay Kumar Narisetty wrote:
> Hi All,
>
> We are using Oracle Standard Edition software. We had a new
> requirement this week to encrypt the databases. Do you
> recommend any  third party software for encrypting databases?
>
> Over database size is 4 TB and If we do encryption on tablespaces do
> we need downtime ? Over oracle database version  oracle 10gr2 /11gr2
> and 19c . We can not use Oracle TDE because of the standard version of
> the database.
>
> Do you guys see performance issues with application reading data with
> encryption ?
>
> Please give me some advice!
>
> Thanks,
> Vinay Narisetty

--
http://www.freelists.org/webpage/oracle-l