OBIEE physical SQL — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE physical SQL

Received Response
12
Views
1
Comments
mmajdana1
mmajdana1 Rank 6 - Analytics Lead

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