1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. TIMINGMESSAGES

TIMINGMESSAGES

The TIMINGMESSAGES configuration setting enables you to control whether Essbase logs the duration of each grid and report query in the application log.

Syntax

TIMINGMESSAGES TRUE | FALSE

  • TRUE—Essbase logs these items:

    • The duration of all grid and report queries in the application log.

    • Timestamps of the queries' execution.

    • Messages about dynamic calculator cache usage for each data retrieval.

    The default setting is TRUE.

  • FALSE—Essbase does not log the query timing information.

Description

TIMINGMESSAGES controls whether Essbase logs the duration of each grid and report query in the application log. Setting TIMINGMESSAGES to FALSE disables the logging of query durations in the application log. If the timing of queries is disabled, Essbase does not have to communicate with the operating system to get query start and finish times. As a result, query execution times may be improved in environments with many concurrent users. Disabling this parameter also decreases the size of the application log.

Example

TIMINGMESSAGES TRUE

Causes Essbase to time and log the duration of queries in the application log. For example: [Thu Nov 26 14:55:32 2020]Local/Sample/Basic/admin/Info(1020055) Spreadsheet Extractor Elapsed Time : [0.078] seconds. 

TIMINGMESSAGES FALSE

Disables the logging of query durations.

See Also

SSLOGUNKNOWN