Excessive Redo generated in R12 compared to 11.5.10.2
I'm not sure if this is aimed at the correct Forum but has anyone else been aware of excessive archivelog generation since going to R12.
I used logminer to track it down to a temporary table GL_BIS_SEGVAL_INT
I believe it has something to do with a Profile setting
Initialization SQL Statement - Custom
which we have set to
BEGIN gl_security_pkg.init; mo_global.init('S',null); END;
My colleague said it was necessary for several Discoverer workbooks to run successfully.
Does anyone know of a work around? Or maybe a Patch even?