My Oracle Support Banner

RACUST - Customer Interface Performance Issue Fetching Millions of Rows (Doc ID 1130873.1)

Last updated on FEBRUARY 12, 2018

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.
Executable:RACUST - Customer Interface


Symptoms

RACUST - Customer interface is having performance issues

Sorted tkprof shows the following as the top query:

select decode(rsu.location,i.location,'w1,','') ,i.rowid
from
hz_cust_site_uses rsu ,hz_cust_accounts rca ,hz_cust_acct_sites rad ,
ra_customers_interface i ,ar_system_parameters syspa where
(((((((i.orig_system_address_ref is not null and i.insert_update_flag='I')
and i.orig_system_customer_ref=rca.orig_system_reference) and
rad.cust_acct_site_id=rsu.cust_acct_site_id) and rsu.site_use_code=
i.site_use_code) and rca.cust_account_id=rad.cust_account_id) and
i.request_id=:b0) and syspa.auto_site_numbering='N') group by rsu.location,
i.location,i.rowid


call    count   cpu      elapsed    disk       query      current    rows
------- ------  -------- ---------- ---------- ---------- ---------- ---------
Parse   1       0.00     0.00       0          8          0          0
Execute 1       0.01     0.01       0          15         0          0
Fetch   6792882 213.95   337.89     2396523    16438224   5803       6792881
------- ------  -------- ---------- ---------- ---------- ---------- ---------
total   6792884 213.97   337.91     2396523    16438247   5803       6792881

Changes

 

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
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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