Clarity: Audit Trail performance problem on object instance pages

Document ID : KB000051055
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Audit Trail on object instance pages like Resource and Project, it has very slow performance.

Steps to Reproduce:

  1. Login Clarity, go to Admin Tool page

  2. Data Administration.

  3. 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:

 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.

Solution:

WORKAROUND:

None.

STATUS/RESOLUTION:

Resolved in Clarity 12.1.1.

Keywords: CLARITYKB, CLRT-54361, clarity12resolved, clarity1211resolved, performance.