Log File for Capturing Session Variables Initialization Block — Oracle Analytics

Oracle Analytics Cloud and Server

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

Log File for Capturing Session Variables Initialization Block

Received Response
51
Views
7
Comments
bskumar.obiee
bskumar.obiee Rank 3 - Community Apprentice

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

  • 3365160
    3365160 Rank 3 - Community Apprentice

    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)

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

    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

  • bskumar.obiee
    bskumar.obiee Rank 3 - Community Apprentice

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

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

    The table does not exist before 11.1.1.9

  • bskumar.obiee
    bskumar.obiee Rank 3 - Community Apprentice

    Do we have any other alternate solution for capturing this?

    Thanks for your valuable inputs!!

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

    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.

  • bskumar.obiee
    bskumar.obiee Rank 3 - Community Apprentice

    Thank you!! Will check after changing the log_level to 5, coz.. 2 wasn't giving me info abt the logs.