Agent Dashboard Slow Performance (Doc ID 2273917.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Customer Support - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Agent Dashboard

ACTUAL BEHAVIOR
---------------
Agent Dashboard Slow Performance

Agent Dashboard is loading very slow..Issue is with users who has large number of SRs to display on dashboard. This user had 860 SRs to display on dashboard. Every time he goes to dashboard page, this SQL will be executed and fetch these rows. This i SQL is fetching large number of rows into oacore JVM from database.
 
This SQL has lot of scalar function calls which is causing large number of executions of these other SQLs (e.g. FND_MENU sql noted below). Even though main SQL takes only 10-11 seconds, because of all these calls, total time to load the page goes more than 40-50 seconds. Page load time is directly proportional to number of SRs to display ..

EXPECTED BEHAVIOR
-----------------------
Agent Dashboard should load more quickly

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open Agent dashboard
2. See performance issue


Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms