Oracle LogMiner and overhead with EBS 12.1.3
Hi,
We are using EBS 12.1.3 and thinking of using LogMiner mainly for Auditing purposes
We did some tests and it appears to be able to get most of the information via LogMiner we need to enable the "Minimum Supplemental Logging" using
SQL> Alter database add supplemental log data;
.
Once we did this we were able to capture more information , but just wondering about the overhead.
Some of the Oracle notes indicates that Minimal supplemental logging does not impose significant overhead on the generation of redo logs and they recommend that you enable it if you plan to use it.
.
But from our tests, when we enabled it , we got a lot more records than when it was disabled.