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 .
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.