This content has been marked as final. Show 5 replies
If you set the loglevel 2 for users then you get the physical query.
You can do this in rpd level or using session variables.
Using Admin tool->Tools->Options->System logging level =2
If helps pls mark as correct
Edited by: veeravalli on Nov 19, 2012 9:23 AM
Yes it is already Log level is 2. i am getting query is still Logical query but i want the Physical qaury that should be excexute in the sql developer .
Anybody please suggest me whether it is possible to get the physical query like this way in OBIEE 11g or not .
Can you tell me about the user and did you try to set the session variable for loglevel and also where you are looking for physical query.
I am trying to get the query for the weblogic user and i did not given for seesion variable for query .
I am looking the query in Advanced tab and Managed session and nquery log .
Please let me know from where i will get phyciscal query apart from these locations.
3rd place to get the physical query is S_NQ_DB_ACCT table.1 person found this helpful
Appreciate if you mark as correct/helpful