This discussion is archived
1 Reply Latest reply: Jan 23, 2013 6:36 PM by Ahsan Shah RSS

OBIEE -10.1.3.4.1 - high physical and logical query response

943971 Newbie
Currently Being Moderated
Hi All,

I am facing an performance issue in OBIEE 10g .My report is taking 2 mins to come up and when i fired the physical query in the db the data is coming in 2 secs.

Below is the details from the log file.Here I observed that response time for physical and logical query is 109 sec ~ 2 mins.Please provide me the helpful pointers.

+++Administrator:370000:370015:----2013/01/22 07:28:04

-------------------- Execution Node: <<2650466>>, Close Row Count = 3332, Row Width = 26000 bytes


+++Administrator:370000:370015:----2013/01/22 07:28:04

-------------------- Execution Node: <<2650466>> DbGateway Exchange, Close Row Count = 3332, Row Width = 26000 bytes


+++Administrator:370000:370015:----2013/01/22 07:28:04

-------------------- Execution Node: <<2650466>> DbGateway Exchange, Close Row Count = 3332, Row Width = 26000 bytes


+++Administrator:370000:370015:----2013/01/22 07:28:04

-------------------- Query Status: Successful Completion


+++Administrator:370000:370015:----2013/01/22 07:28:05

-------------------- Rows 3332, bytes 86632000 retrieved from database query id: <<2650466>>


+++Administrator:370000:370015:----2013/01/22 07:28:05

-------------------- Physical query response time 109 (seconds), id <<2650466>>


+++Administrator:370000:370015:----2013/01/22 07:28:05

-------------------- Physical Query Summary Stats: Number of physical queries 1, Cumulative time 109, DB-connect time 0 (seconds)


+++Administrator:370000:370015:----2013/01/22 07:28:05

-------------------- Rows returned to Client 3332


+++Administrator:370000:370015:----2013/01/22 07:28:05

-------------------- Logical Query Summary Stats: Elapsed time 109, Response time 109, Compilation time 0 (seconds)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points