Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Log File for Capturing Session Variables Initialization Block

Is there a log file which will provide information of all the Session variable's INIT block execution whenever a user logins to OBIEE? I was not able to find it in NQQuery.log, Could you please point me to the correct location?
Answers
-
Connect you to administration-> manage sessions
You will see all the users connected and each of the requests sent.
If you want to view the physical requests sent directly to the database, you can configure the server logs in the EM to "Accurate" (EM-> Business Intelligence -> Diagnostics)
0 -
If you are using any version after 11.1.1.9 and have properly set up usage tracking then the information will be in S_NQ_INITBLOCK
https://docs.oracle.com/middleware/11119/biee/BIESG/usage_track.htm#CIHEBBGH
0 -
Thanks Christian! But we are still on 11.1.1.7.14 .. Usage Tracking is already in use.. Will try to check on table you have mentioned..
0 -
The table does not exist before 11.1.1.9
0 -
Do we have any other alternate solution for capturing this?
Thanks for your valuable inputs!!
0 -
The log files (nq server / query) have the information if you're logging high enough. 2 may be enough otherwise go to 5. But physically or with regards to UT there's no chance but to move to a newer version....which you should do anyways.
0 -
Thank you!! Will check after changing the log_level to 5, coz.. 2 wasn't giving me info abt the logs.
0