How to fetch the physical query using usage tracking in OBIEE 11g, i hope in OBIEE 11g there is a feature to capture the physical query using S_NQ_DB_ACCT.
I have imported the table S_NQ_ACCT and S_NQ_DB_ACCT in to RPD.
Please let me know how to join these two tables(Using which Key).
Thanks for your reply. Usage Tracking is working fine, The issue is how to join these two tables S_NQ_ACCT and S_NQ_DB_ACCT. (i.e using which keys)
I am looking for the physical query from S_NQ_DB_ACCT table.