My Oracle Support Banner

C1-RFPAYSRH1 Performance Issue (Doc ID 2716645.1)

Last updated on OCTOBER 12, 2020

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.6.0.1.0 and later
Information in this document applies to any platform.

Symptoms

On RMB v2.6.0.1.0, C1-RFPAYSRH1 batch seeing a Performance hit.

DBA finds no optimized plans after checking in sql tuning advisor.
Oracle tuning advisor shows below recommendations:

'create index CISADM.IDX$$_2F4520008 on CISADM.CI_FT("FT_TYPE_FLG","FREEZE_SW","SA_ID")';
'create index CISADM.IDX$$_2F4520007 on CISADM.CI_PAY_TNDR("TNDR_STATUS_FLG","PAYOR_ACCT_ID","PAY_EVENT_ID")';
'create index CISADM.IDX$$_2F4520006 on CISADM.CI_FT("MATCH_EVT_ID","FT_TYPE_FLG")';
'create index CISADM.IDX$$_2F4520005 on CISADM.CI_PAY("PAY_EVENT_ID","PAY_STATUS_FLG")';
'create index CISADM.IDX$$_2F4520003 on CISADM.CI_SA_TYPE("SPECIAL_ROLE_FLG","SA_TYPE_CD")';
'create index CISADM.IDX$$_2F4520002 on CISADM.CI_PAY("PAY_STATUS_FLG")';
'create index CISADM.IDX$$_2F4520004 on CISADM.C1_REF_WO_REQ_DTLS("ENTITY_TYPE","ENTITY_ID","REF_WO_REQ_ID")';

Creating a Sql profile [execute dbms_sqltune.accept_sql_profile (task_name => 'sqlt_s6xxxx_mem', replace => TRUE);] execution still sees  52 seconds leading Time-Out.

We are getting major timeouts and users are unable to proceed and it needs a resolution.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.