OBIEE 10G/11G - Nqquery.log (Query logging)

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics)

1 - About

It's the log file of BI Server showing information about the process of a logical SQL query.

It's located in the directory:

  • 10g: BI_ORACLE_HOME/server/Log
  • 11g: ORACLE_INSTANCE/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

To extract the informations contain in this file, you can :

Oracle BI Server query logging is tracked at a user level. It is a resource-intensive process if you track the entire user community. For production systems, it is recommended that query logging be enabled only for a very targeted user community. In production systems, you can use Usage tracking as the production-level logging facility

NqQuery.log file shows Physical SQL Query, logical execution plan where Usage tracking does not have this information.

You can define the amount of information written by setting the loglevel.

You can query this log file online. See WebLogic - Diagnostics Framework (WLDF)

Advertising

3 - Configuration

3.1 - 10G

In the nqsconfig.ini file, you can change two parameters :

# ##############################################################################
# User Log Section
# The user log NQQuery.log is kept in the server\log directory. It logs
# activity about queries when enabled for a user. Entries can be
# viewed using a text editor or the nQLogViewer executable.
# ##############################################################################

[USER_LOG]

USER_LOG_FILE_SIZE = 10 MB;   // default size
CODE_PAGE = "UTF8";           // ANSI, UTF8, 1252, etc.

4 - Documentation / Reference