EBS R12.1.3 : e:PO:wf:POAPPRV module question.
Hi,
We have recently went live in R12.1.3. On some days, due to transactions in wf:POAPPRV , we see huge amount of redo log generation. I was able to see 11 million records in MRP_RELIEF_INTERFACE table . I am not able to understand, how this table is updated. I am not a functional guy but a DBA. I am trying to identify root cause of excessive Redolog generation.
our DB size is around 120 GB and redolog generation is 78 GB on some days .
From AWR reports,
Segments by DB Blocks Changes
Owner Tablespace Name Object Name Subobject Name Obj. Type DB Block Changes % of Capture