Kumar Kambam’s OBIEE Blog

Intelligence on Oracle Business Intelligence

OBIEE Performance Tuning Tip – Turn off Query Logging

 

Though query logging has immeasurable development value, do not use this for regular production users as the runtime logging cost is extremely high. Every log item is flushed to the disk, which in turn hurts query response. Also, note that the query log files are not created on per user or query basis, there is only one query log per OBIEE server and it would have exclusive lock on the log file, which kills concurrent performance.

On the other hand, usage tracking has a very low runtime cost and is preferred to monitor the queries being used.

Advertisements

January 19, 2009 - Posted by | OBIEE Performance Tuning | , , ,

3 Comments »

  1. Hi
    I am having one qustion
    I have develope one report in OBIEE when i am runing it it takes more time at same time if i run the log sql in sqldeveloper it takes expected time

    why this happens can you help me

    Thnak
    dhananjay

    Comment by dhananjay | February 23, 2009

  2. Hello Every one.
    I have one question here. Could you help me out in sharing the issues and solutions you got during your work experience.

    Comment by Praveen | June 15, 2009

  3. Hi Kumar, is there a specific document for us to refer to on Performance Tuning for OBIEE?

    Comment by LynxLee | July 6, 2009


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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: