0 Replies Latest reply on May 21, 2018 2:18 PM by sys_dba

    Bad database performance on Encrypted block device with LUKS

    sys_dba

      HI guys,

       

      I have an urgent issue that someone might be able to assist me with.

       

      Here goes....

       

      To comply with some  security regulatory requirement, I have been provided with an encrypted ext4  LUN upon which I have created a tablespace.  The encryption software is mcrypt with LUKS.  The database is 11gR2.

       

      The read/write rate on the partition before tablespace was created has dropped down by 90% in oracle read/write operations.

       

      Does anyone have experience with mcrypt with LUKS and what database parameter might also be required to correct this anomalies please?

       

      I have looked at dbwr_io_slaves and db_writer_processes parameters to no avail.

       

      Regards,

       

      Timothy