The actual Executed SQL or SQL steps. — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

The actual Executed SQL or SQL steps.

Received Response
1
Views
2
Comments
mlov83
mlov83 Rank 4 - Community Specialist
edited Aug 13, 2024 6:12PM in Oracle Analytics Cloud and Server

Hey Guys,

So I have now been playing with OBIEE for over a month and things are starting to make more sense. Question that I still seemed to be fuzzy about is, where can I see the actual execution steps that OBIEE is actually doing. In other words I know that I can see the actual sql being send from the interface but that just looks like is selecting from the model. The question I really have is where is the actual sql that is being sent to the database. I can't seem to be able to find that under any log, but  I will admit there are so many logs I could have possibly  missed one.

Any help you guys can offer would be greatly appreciated.

Thanks!

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    In the admin page where you see the sessions in the logs you are supposed to see the LSQL and then the physical SQL (as long as your query doesn't hit the cache). If you don't see it (and it's not the cache) then just increase your log level a bit.

    It's all about the log level if you don't see the physical query ...

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    nqquery.log (in 11g; bi-querylog or sth in 12c). You can also see it under Administration -> Manage Sessions. Your log level needs to be at 2 though (minimum - pumping it higher gives you more info).