I have an urgent issue that someone might be able to assist me with.
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.