Audit Trail on object instance pages like Resource and Project, it has very slow performance.
Steps to Reproduce:
When verified in the customer's AWR report and validated their execution plans, the below tables have full table scan:
ODF_AUDITED_ATTRIBUTES ODF_AUD_OBJ_INST_CONTEXT CMN_AUDITS SRM_RESOURCES CMN_AUDITS_TSV
Expected Result: Page should be returned within reasonable time.
Actual Result: It took 20-30 minutes to finish or time out.
Resolved in Clarity 12.1.1.
Keywords: CLARITYKB, CLRT-54361, clarity12resolved, clarity1211resolved, performance.