Performance - EBS (MOSC)

MOSC Banner

Oracle LogMiner and overhead with EBS 12.1.3

edited Sep 5, 2016 5:00AM in Performance - EBS (MOSC) 6 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center