Latency is seen in expression queue execution when unusually large number of expressions are queued up with the database Oracle 10g and Oracle 11g.
The problem is reported when user actions triggers large number of expression evaluations. It can be triggered in below scenario
- Importing a new workspace from template
- Importing or updating elements
The resulting spike in expression queue table size, will stale the statistics and the execution plan is non-optimal.
Oracle 10g , Oracle 11g
Diagnosing the problem
Oracle database reports like ADDM , AWR show the top slowest query with each query taking more time to complete.
Resolving the problem
Database Administrator (DBA) should perform SQL tuning using the Oracle Enterprise Manager to run the advisor and pick optimal execution plans from alternatives.