1 Reply Latest reply: Jan 23, 2013 8:36 PM by Ahsan Shah RSS

    OBIEE -10.1.3.4.1 - high physical and logical query response

    user13726992
      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)