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

MAXLOGINS

This Essbase configuration setting sets a limit on the number of user sessions that can be connected to the Essbase Server at any one time.

Syntax

MAXLOGINS n

n—Any integer from 1000 to 1048575 is valid. The default value is 10000.

Description

This setting limits the maximum number of user sessions allowed to connect to the Essbase Server at any one time. This number includes multiple instances of the same user.

You may wish to adjust the value of MAXLOGINS to match computer resources, or to more closely manage concurrent ports and user sessions. A concurrent port is used for each unique combination of client machine, Essbase Server and login name. For example, the same user with five open Excel worksheets connected to the same Essbase Server use one port, but five sessions.

Notes

  • Increasing the value of MAXLOGINS increases memory use approximately 6 bytes per user session.

  • If the setting is less than the minimum value, 1000, the value is assumed to be 1000.

Example

MAXLOGINS 50000

Increases the maximum number of simultaneous logins possible, from the default of 10000 to 50000.