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

    Bad database performance on Encrypted block device with LUKS


      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.