ORACLE BUSINESS INTELLIGENCE WORLD

Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles





  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 354,025 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Setting logging Levels

Posted by Santosh Kumar Gidadmani on March 3, 2011

Login level is used to control the number of information generated in the log file. There are couple of benefits associated with using logging levels like to monitor activity on your system, to help solve performance problems etc.

The logging system is turned off by default. You need to enable logging on the system for each user whose queries you want logged and You cannot configure logging levels for a group, it has to be on individual users level.

Type of Login Levels
There are 5 types of login levels available in OBIEE.

Login Levels Descriptions of Results
0 No logging
1 Logs the SQL statement issued from the client application.
Logs elapsed times for query compilation, query execution, query cache processing, and back-end database processing.
Logs the query status (success, failure, termination, or timeout). Logs the user ID, session ID, and request ID for each query.
2 Logs everything logged in Level 1.
Additionally, for each query, logs the repository name, business model name, presentation catalog (called Subject Area in Answers) name, SQL for the queries issued against physical databases, queries issued against the cache, number of rows returned from each query against a physical database and from queries issued against the cache, and the number of rows returned to the client application.
3 Logs everything logged in Level 2.
Additionally, adds a log entry for the logical query plan, when a query that was supposed to seed the cache was not inserted into the cache, when existing cache entries are purged to make room for the current query, and when the attempt to update the exact match hit detector fails.
Do not select this level without the assistance of Technical Support.
4 Logs everything logged in Level 3.
Additionally, logs the query execution plan. Do not select this level without the assistance of Technical Support.
5 Logs everything logged in Level 4.
Additionally, logs intermediate row counts at various points in the execution plan. Do not select this level without the assistance of Technical Support.
6 & 7 Reserved for future use

Source Reference: OBIEE Guide

How to set up logging level for users
Navigate to Admin tool -> Manage – > Security -> Users
Double click on a user and change the Logging level
To disable the logging level, set the level to Zero

Note: A session variable overrides a user’s logging level.

Setting for a specific Request
You can set the LOGLEVEL variable for a specific request
Select to Modify a request or create a new one
Navigate to the Advanced Tab
In the Prefix Text Box type “SET VARIABLE LOGLEVEL=0;” (set to any log between 0-5)
Now when you navigate to the results tab an entry will be made to the log file

Example:

– Santosh

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: