3 Replies Latest reply: Aug 29, 2013 7:13 PM by Sasi Nagireddy RSS

    I can't find SQL statement in Nqqurey.log

    Loat

      hi, All

       

      I installed OBIEE 11g and BI APPS 7.9.6.   I already set the loglevel = 2 . When I tried to found out the physcial query in Nqquery.log. I got this log:

      ------------------------------------

      Ledger Name is equal to O_JA_LEDGER(PRC GAAP)

      and Fiscal Quarter is equal to 2012 Q 3

      and Fiscal Year is equal to 2012

       

       

       

      SQL Request, logical request hash:

      29c96099

      set variable LOGLEVEL = 5;SELECT "Ledger"."Ledger Name" saw_0 FROM "Financials - GL Balance Sheet" ORDER BY saw_0

       

       

      ]]

      [2013-08-29T12:32:54.000+08:00] [OracleBIServerComponent] [TRACE:5] [USER-23] [] [ecid: edb4054bccf19c8a:5cea7a08:140c8514f9f:-8000-0000000000001458] [tid: 1a54] [requestid: 320f0001] [sessionid: 320f0000] [username: weblogic] -------------------- General Query Info: [[

      Repository: Star, Subject Area: Core, Presentation: Financials - GL Balance Sheet

       

      ]]

      [2013-08-29T12:32:54.000+08:00] [OracleBIServerComponent] [TRACE:5] [USER-2] [] [ecid: edb4054bccf19c8a:5cea7a08:140c8514f9f:-8000-0000000000001458] [tid: 1a54] [requestid: 320f0001] [sessionid: 320f0000] [username: weblogic] -------------------- Logical Request (before navigation): [[

       

      RqList  distinct

          Dim - Ledger.Ledger Name as c1 GB

      OrderBy: c1 asc

       

      ]]

      [2013-08-29T12:32:54.000+08:00] [OracleBIServerComponent] [TRACE:5] [USER-50] [] [ecid: edb4054bccf19c8a:5cea7a08:140c8514f9f:-8000-0000000000001458] [tid: 1a54] [requestid: 320f0001] [sessionid: 320f0000] [username: weblogic] -------------------- The logical query hits the plan cache [[

      plan

      RqList <<680766>> [for database 0:0,0]

          D1.c1 as c1 [for database 0:0,0]

      Child Nodes (RqJoinSpec): <<680770>> [for database 0:0,0]

          RqJoinNode <<680771>> []

              (

                  RqList <<680774>> [for database 0:0,9]

                      1 as c1 [for database 0:0,9]

                  Child Nodes (RqJoinSpec): <<680778>> [for database 0:0,9]

                      RqJoinNode <<680779>> []

                          CacheTable T1377750624:515:22648:0CDDF8A8

              ) as D1

       

      ]]

      [2013-08-29T12:32:54.000+08:00] [OracleBIServerComponent] [TRACE:5] [USER-16] [] [ecid: edb4054bccf19c8a:5cea7a08:140c8514f9f:-8000-0000000000001458] [tid: 1a54] [requestid: 320f0001] [sessionid: 320f0000] [username: weblogic] -------------------- Execution plan: [[

       

      RqList <<680766>> [for database 0:0,0]

          D1.c1 as c1 [for database 0:0,0]

      Child Nodes (RqJoinSpec): <<680770>> [for database 0:0,0]

          RqJoinNode <<680771>> []

              (

                  RqList <<680774>> [for database 0:0,9]

                      1 as c1 [for database 0:0,9]

                  Child Nodes (RqJoinSpec): <<680778>> [for database 0:0,9]

                      RqJoinNode <<680779>> []

                          CacheTable T1377750624:515:22648:0CDDF8A8

              ) as D1

       

      ]]

      [2013-08-29T12:32:54.000+08:00] [OracleBIServerComponent] [TRACE:5] [USER-20] [] [ecid: edb4054bccf19c8a:5cea7a08:140c8514f9f:-8000-0000000000001458] [tid: 1a54] [requestid: 320f0001] [sessionid: 320f0000] [username: weblogic] -------------------- Execution Node: <<680774>>, Close Row Count = 11, Row Width = 68 bytes [[

       

      ]]

      [2013-08-29T12:32:54.000+08:00] [OracleBIServerComponent] [TRACE:5] [USER-20] [] [ecid: edb4054bccf19c8a:5cea7a08:140c8514f9f:-8000-0000000000001458] [tid: 1a54] [requestid: 320f0001] [sessionid: 320f0000] [username: weblogic] -------------------- Execution Node: <<680766>> Projection, Close Row Count = 11, Row Width = 68 bytes [[

       

      ]]

      [2013-08-29T12:32:54.000+08:00] [OracleBIServerComponent] [TRACE:5] [USER-34] [] [ecid: edb4054bccf19c8a:5cea7a08:140c8514f9f:-8000-0000000000001458] [tid: 1a54] [requestid: 320f0001] [sessionid: 320f0000] [username: weblogic] -------------------- Query Status: Successful Completion [[

       

      ]]

      [2013-08-29T12:32:54.000+08:00] [OracleBIServerComponent] [TRACE:5] [USER-29] [] [ecid: edb4054bccf19c8a:5cea7a08:140c8514f9f:-8000-0000000000001458] [tid: 1a54] [requestid: 320f0001] [sessionid: 320f0000] [username: weblogic] -------------------- Physical Query Summary Stats: Number of physical queries 1, Cumulative time 0, DB-connect time 0 (seconds) [[

       

      ]]

      [2013-08-29T12:32:54.000+08:00] [OracleBIServerComponent] [TRACE:5] [USER-24] [] [ecid: edb4054bccf19c8a:5cea7a08:140c8514f9f:-8000-0000000000001458] [tid: 1a54] [requestid: 320f0001] [sessionid: 320f0000] [username: weblogic] -------------------- Rows returned to Client 11 [[

       

      ]]

      [2013-08-29T12:32:54.000+08:00] [OracleBIServerComponent] [TRACE:5] [USER-33] [] [ecid: edb4054bccf19c8a:5cea7a08:140c8514f9f:-8000-0000000000001458] [tid: 1a54] [requestid: 320f0001] [sessionid: 320f0000] [username: weblogic] -------------------- Logical Query Summary Stats: Elapsed time 0, Response time 0, Compilation time 0 (seconds) [[

       

      ]]

      [2013-08-29T12:35:31.000+08:00] [OracleBIServerComponent] [TRACE:2] [USER-0] [] [ecid: edb4054bccf19c8a:5cea7a08:140c8514f9f:-8000-000000000000149b] [tid: 1a54] [requestid: 320f0001] [sessionid: 320f0000] [username: weblogic] ############################################## [[

       

       

      there  is not any physcial statement  in log. Could any one help me ?

       

      thanks

      Tao