OBIEE 11g : How to set log level?

OBIEE 11g : How to set log level?

In previous post we have seen query logging introduction.

OBIEE 11g : Query Logging

In this post we will see how we can set log level.

We can enable logging level for individual users, system user, and individual request.

1.  For Individual analysis(Temporary log):

While diagnosing query performance or data issue we may need to set temporary log level for a query.

For this we need to set Log_level system variable in advanced tab of analysis.

Add below code in prefix and click Apply Sql.

SET VARIABLE LOG_LEVEL=2;

 This will fetch log only for desired analysis.

2.  For Individual User:

We can set log level for individual user in two ways.

1.       a.  Initializing Loglevel Session Variable:

We can set log level for each user by setting the loglevel system session variable via an initialization block.

b.  Using User Dialog:

a.    In the Administration Tool, select Manage > Identity (11g). The Security Manager dialog box appears.

b.    Double-click the user's user ID. The User dialog box appears.

c.    Set the logging level by clicking the Up or Down arrows next to the Logging Level field.

3.  System Log Level:

You can find a default logging level in the options>Repository tab of the repository.

This will set a system level default log level that will fetch logs for all users as well as all analysis.