1663672 - Web Intelligence query runs infinitely and Oracle process reaches 100% CPU

Symptom

• Unable to refresh or run a Webi Query in Infoview
• Query turns for hours without returning any results
• Oracle process reaches 100% CPU usage

Environment

• Business Objects Enterprise Xi 3.1 SP3
• Oracle 10.2.0.4.0

Reproducing the Issue

1. Logon to Infoview
2. Create a Webi report based on Oracle database
3. Click run
4. The query runs infinitely

Cause

• This is not a BOE defect but an optimization and configuration tuning on Database side issue.
• Oracle calculates every time, a different execution plan instead of reusing the plan of an already executed query.

Resolution

 Modify the value of the Oracle parameter CURSOR_SHARING to FORCED.
Note:

• Oracle does not recommend setting CURSOR_SHARING to FORCE in a DSS environment or if complex queries are used.
• Star transformation is not supported with CURSOR_SHARING set to FORCE. 

See Also

For more information see Also:
http://docs.oracle.com/cd/B19306_01/server.102/b14211/memory.htm

Keywords

oracle 100% cpu, webi, turn, runs infinitely, no results

Header Data

Released On	19.12.2011 17:51:34
Release Status	Released to Customer
Component	BI-RA-WBI Web Intelligence
Priority	Normal
Category	Problem
Database	ORACLE 10.2.0.4.0