OBIEE Query Taking Long time
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.
Answers
-
in the advanced tab of your report
enter in Prefix part
SET VARIABLE DISABLE_CACHE_HIT=1,LOGLEVEL=2;
Click apply.. Run your report again. go to administration ->sessions and check what is the physical query generated there .
0 -
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?
0 -
Log level 2 won't tell you much. Push it to 5 so you see what's happening inside the server as Gianni said.
0 -
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.
0 -
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
0 -
Log. Post the FULL log.
0
