Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE physical SQL

mmajdana1Dec 3 2018 — edited Dec 6 2018

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!

This post has been answered by Joel Acha on Dec 3 2018

Jump to Answer

Added on Dec 3 2018

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

1 comment

605 views