OBIEE 10G/11G - Nqquery.log (Query logging)
Table of Contents
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 :
- use the nqlogviewer utility
- open the file with a text editor
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)
Articles Related
Configuration
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.