Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 39 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 275 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI Trainings
- 17 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OBIEE physical SQL
Hi I am Using OBIEE 12.1.2.0
I want to knopw how to see Physical SQL that is run against the database.
I go in Manage sessions , I took the query that is sent to BI Server, and paste it into Issue SQL, I raise logging level to 2(I tried every possible logging level)
and still when i go to View log it does not contain Physical SQL.
I tried call SAPurgeAllCache(); before isuuing SQL and it still did not help.
Any advice form anyone, is there something I am doing wrong??
Best regards, Matija!
Answers
-
In the Advanced tab of your analysis, set the prefix to:
SET VARIABLE DISABLE_CACHE_HIT=1, LOGLEVEL=2;
See - Oracle Support Document 1902667.1 (OBIEE 11g How to see the Physical Query Sent to the Database from an Analysis?) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1902667.1
0
