top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to get real physical SQL sent by OBIee to the database?

+1 vote
408 views
How to get real physical SQL sent by OBIee to the database?
posted Aug 11, 2016 by Abhimanyu Singh

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

First of all, check the value of your session variable LOGLEVEL.
5 is fine.
Then, go into Administration -> Manage sessions.
Find your query (at the bottom of the list), and click on “View log”.
If you hit the cache, you will see “cache hit on query”. Otherwise, you will see the physical SQL below the logical SQL.

answer Aug 12, 2016 by Manikandan J
...