Audit Trail on object instance pages like Resource and Project, it has very slow performance.
Steps to Reproduce:
- Login Clarity, go to Admin Tool page
- Data Administration.
- Click on Audit Trial tab.
When verified in the customer's AWR report and validated their execution plans, the below tables have full table scan:
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.