Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OBIEE Query Taking Long time

User_IP06IFeb 8 2021

Hello All,
I have a query that is running for 1-2 seconds in the database but for 4 minutes in OBIEE. It's a simple query that has three columns including one ID column which is used to filter. Did anyone face this issue? Are there any parameters in RPD or OBIEE server that can be adjusted to improve performance.

Thanks in Advance.

Comments

asim cholas

in the advanced tab of your report
enter in Prefix part
SET VARIABLE DISABLE_CACHE_HIT=1,LOGLEVEL=2;

image.png

Click apply.. Run your report again. go to administration ->sessions and check what is the physical query generated there .

Gianni Ceresa

@user-ip06i ,
OBIEE doesn't have any "go_fast=42" configuration flag. The tool does what you tell it to do based on the model you provided and the settings.
Start analyzing what happen, where and when. What is performed during these 4 minutes?

Log level 2 won't tell you much. Push it to 5 so you see what's happening inside the server as Gianni said.

User_IP06I

Thank you for the response. The model is a simple star schema. also, I'm only pulling fields from one table. May I know what are the other settings you mean?
I got the query from the Admin tab. @user-ip06i
Select ID, NAME, DATE from Table where ID = 'XX'.
Database returns the results in 1-2 seconds but OBIEE is running and running for a long time.

asim cholas

what is the table size in database ? May be the result set you are getting quickly from database cache. check the query cost. If it is low , then next possibility is network connection between your bi server and database server. Run the full query in database including "WITH" clause. Or post your query here

Christian Berg-0racle

Log. Post the FULL log.

1 - 6