OBI LOG LEVEL Application Setting

Group. OBI

Type. Setting

Application.

OBI

PMS

S&C

Description. When OBI reports and ad hoc queries are run, users may want to view corresponding performance data in the nqquery.log (oracle\oraclebi\server\log\NQQuery.log). The OBI LOG LEVEL application setting provides the level and type of data desired for a log entry. The default level is 0 (no logging), while the highest level is 5. Setting this parameter to a level higher than 0 may impact the performance of all OBI reports.

For more explanation of the OBI Query Log (nqquery.log), refer to the OBIEE Server Administration Guide (http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/b31770.pdf).

Internal Name. OBI_LOGLEVEL

Property Determination.

Activation / Inactivation Rules.

The OBI LOG LEVEL setting is available when a full OBI license is active (OBIEE Enterprise, OPB_<version number>).

Available Values.

0 NO LOGGING

1 ELAPSED TIMES AND STATUS

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 LEVEL 1 PLUS SQL AND NO OF ROWS
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 LEVEL 2 PLUS LOGICAL QUERY PLAN
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 LEVEL 3 PLUS EXECUTION PLAN
Do not select this level without the assistance of Technical Support.
5 LEVEL 4 PLUS INTERMEDIATE ROW COUNTS
Do not select this level without the assistance of Technical Support.

Add On Licenses/Country Specifics.

Other Application Settings.

<none>

Affected Areas

Menus / Screens / Fields.

<none>

Reports & Report Forms.

<none>

Permissions.

<none>

Notes.

nqquery.log (oracle\oraclebi\server\log\NQQuery.log)