Awesome, thats what I thought, so in that case, if I want to install Essbase server on Linux, I have to download the essbase files for linux and select only the essbase server while installing, and if I want to install essbase components on windows, I have to download the same set of files but for Windows OS and select to install only the essbase components that I need.

Oracle® Essbase

Release 11.1.2.1.000 Patch Set (PS): 11.1.2.2.000

Readme

This Readme file describes the defects fixed in this patch set (PS) and the requirements and instructions for applying this PS.

Who should apply this patch: This PS contains defect fixes and changes that are specific to the Oracle Exalytics In-Memory machine. You should install this PS only in the following circumstances:

·You are installing Essbase on the Exalytics In-Memory Machine, or

·There is an urgent need for a defect fix that is included in this PS

Customers considering this PS for a platform other than the Exalytics In-Memory Machine should carefully review the list of fixed defects. If there is not a truly urgent need for a defect fix included in this PS, Oracle recommends customers install the upcoming Enterprise Performance Management (EPM) 11.1.2.2.000 release, which will contain an update, instead of this patch set. To check the availability of the EPM 11.1.2.2.000 release prior to installing this PS, visit the Oracle Software Delivery Cloud (https://edelivery.oracle.com).

Oracle highly recommends that you do extensive testing before making this patch available in a general production environment.

Caution: Once applied, you cannot roll back this patch or any other Essbase 11.1.2.2.000 component patch.

Also see the Essbase New Features.

This patch set replaces files in the existing installation and does not require a full installation.

This patch set includes patches for these components:

·Essbase Server (Patch ID 11865143)

·Essbase Client (Patch ID 11865133)

·Common Runtime Client (Patch ID 12911847)

This patch set is cumulative and includes Essbase 11.1.2.1.102.

You can apply this patch to the following releases:

·11.1.2.1

·11.1.2.1.102

Other Required Patches

Installation of Oracle Essbase 11.1.2.1.000 is a prerequisite for installing the server patch.

The user applying the patch should be the user who was set up to install and configure EPM System products. Required user privileges or rights:

Windows:
Use the user account that has Local administrator rights and was set up for installation and configuration. This user is an administrator and is the same for all EPM System products. Assign local policies if required by the product. Such assignments typically are: 'Act as part of the operating system, Bypass traverse checking, Log on as a batch job, Log on as a service.'

UNIX/Linux:
Use the account that was used to install EPM System products and has Read, Write, and Execute permissions on $MIDDLEWARE_HOME. If you installed other Oracle products, the user who installed EPM System products must be in the same group as the user who installed the other Oracle products. OPatches are not intended to be applied using a root user.

The Essbase Server component in this patch set is supported on Windows (32-bit and 64-bit) and Linux (64-bit) platforms only.

The Essbase Client and Common Runtime Client components in this patch set apply to all supported platforms, with the exception of Solaris 9 (also known as Solaris 2.9 or 5.9).

Defects Fixed in this Patch

Use the Defects Fixed Finder tool to review the list of defects fixed prior to release 11.1.2.2.000. This tool is available at:

The following issues are the noteworthy known issues of this patch.

This patch applies to all supported platforms, with the exception of Solaris 9 (also known as Solaris 2.9 or 5.9).

CAUTION: The Essbase security file (essbase.sec) in PS 11.1.2.2.000 is incompatible with Essbase 11.1.2.1 or 11.1.2.1.102, which are the supported releases for this patch. Therefore, if you apply the Essbase Server patch, it or any other Essbase 11.1.2.2.000 component patch cannot be rolled back.

NOTE: If you are using Essbase Integration Services 11.1.2.1 with Essbase 11.1.2.2.000, before applying these patches, perform the additional steps that are outlined in defect 13868678 (see the 'Known Issues in this Patch' section).

This section includes important information about applying this patch to the following components.

To apply this patch:

2.Download and unzip the downloaded patch file, <PATCH FILE NAME>.zip, to the <EPM_ORACLE_HOME>/OPatch directory (by default, Oracle/Middleware/EPMSystem11R1/OPatch).
NOTE: <PATCH FILE NAME>.zip is the name that My Oracle Support assigns to this patch. When you download the file, a message indicates the file name.

3.On the server on which Essbase Server runs, from a command line, change the directory to <EPM_ORACLE_HOME>/OPatch.

4.To apply the patch, enter the following command on one line:

Windows:
opatch.bat apply <EPM_ORACLE_HOME>/OPatch/11865143 -oh <EPM_ORACLE_HOME>
-jre <MIDDLEWARE_HOME>/jdk160_21
NOTE: The default for <EPM_ORACLE_HOME> is C:/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is C:/Oracle/Middleware.
UNIX/Linux:
./opatch apply <EPM_ORACLE_HOME>/OPatch/11865143 -oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>/jdk160_21 -invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc

NOTE: The default for <EPM_ORACLE_HOME> is $HOME/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is $HOME/Oracle/Middleware.

5.Restart the services that you stopped in Step 1.

To apply this patch:

1.Stop any Oracle services or applications that may be using Essbase files.

2.Download and unzip the downloaded patch file, <PATCH FILE NAME>.zip, to the <EPM_ORACLE_HOME>/OPatch directory (by default, Oracle/Middleware/EPMSystem11R1/OPatch).
NOTE: <PATCH FILE NAME>.zip is the name that My Oracle Support assigns to this patch. When you download the file, a message indicates the file name.

3.On the server on which the Essbase Client runs, from a command line, change the directory to <EPM_ORACLE_HOME>/OPatch.

4.To apply the patch, enter the following command on one line:

Windows:
opatch.bat apply <EPM_ORACLE_HOME>/OPatch/11865133 -oh <EPM_ORACLE_HOME>
-jre <MIDDLEWARE_HOME>/jdk160_21
NOTE: The default for <EPM_ORACLE_HOME> is C:/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is C:/Oracle/Middleware.
UNIX/Linux:
./opatch apply <EPM_ORACLE_HOME>/OPatch/11865133 -oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>/jdk160_21 -invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc
NOTE: The default for <EPM_ORACLE_HOME> is $HOME/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is $HOME/Oracle/Middleware.

5.Restart the services that you stopped in Step 1.

To apply this patch:

1.Stop any Oracle services or applications that may be using Essbase files.

2.Download and unzip the downloaded patch file, <PATCH FILE NAME>.zip, to the <EPM_ORACLE_HOME>/OPatch directory (by default, Oracle/Middleware/EPMSystem11R1/OPatch).
NOTE: <PATCH FILE NAME>.zip is the name that My Oracle Support assigns to this patch. When you download the file, a message indicates the file name.

3.On the server on which the Common Runtime Client runs, from a command line, change the directory to <EPM_ORACLE_HOME>/OPatch.

4.To apply the patch, enter the following command on one line:

Windows:
opatch.bat apply <EPM_ORACLE_HOME>/OPatch/12911847 -oh <EPM_ORACLE_HOME>
-jre <MIDDLEWARE_HOME>/jdk160_21
NOTE: The default for <EPM_ORACLE_HOME> is C:/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is C:/Oracle/Middleware.
UNIX/Linux:
./opatch apply <EPM_ORACLE_HOME>/OPatch/12911847 -oh <EPM_ORACLE_HOME> -jre <MIDDLEWARE_HOME>/jdk160_21 -invPtrLoc <EPM_ORACLE_HOME>/oraInst.loc
NOTE: The default for <EPM_ORACLE_HOME> is $HOME/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is $HOME/Oracle/Middleware.

5.Restart the services that you stopped in Step 1.

The Essbase security file (essbase.sec) in PS 11.1.2.2.000 is incompatible with Essbase 11.1.2.1 or 11.1.2.1.102, which are the supported releases for this patch. Therefore, if you apply the Essbase Server patch, it or any other Essbase 11.1.2.2.000 component patch cannot be rolled back.

Troubleshooting FAQs

How can I find out which releases and patches of EPM System products are installed in a deployment?

In EPM System Release 11.x, you can use the lsinventory command to OPatch to find the release and patches that are installed in an Oracle Home. For example, enter the following command on one line:

Windows:

opatch.bat lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_21

NOTE: The default for <EPM_ORACLE_HOME> is C:/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is C:/Oracle/Middleware.

UNIX/Linux:

./opatch lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_21

NOTE: The default for <EPM_ORACLE_HOME> is $HOME/Oracle/Middleware/EPMSystem11R1. The default for <MIDDLEWARE_HOME> is $HOME/Oracle/Middleware.

Why do I get the following patch conflict error message when running OPatch?

If the patch that you apply conflicts with a previously applied patch, you may receive the following error message when running OPatch:

Patch(es) <PreviousPatch#> conflict with the patch currently being installed (<NewPatch#>).

If you continue, patch(es) <PreviousPatch#> will be rolled back and the new patch (<NewPatch#>) will be installed.

If a merge of the new patch (<NewPatch#>) and the conflicting patch(es) (<PreviousPatch#>) is required, contact Oracle Support Services and request a Merged patch.

This error is returned when one patch attempts to update a previously patched file. When this conflict happens, you can either (1) roll back the previous patch and apply the new patch (this action might be appropriate if the previous patch was not critical) or (2) request a 'merged patch' consisting of the new patch and the patch that it conflicts with. To request a merged patch, contact your Oracle Support representative.

Why do I get the OUI-67078 warning message when applying OPatch?

This warning means that the patch being applied is a superset of a patch already on the deployment and the existing patch will be rolled back. The following snippet shows the context of this warning.

The following warnings have occurred during OPatch execution:
1) OUI-67078:Interim patch 12345678 is a superset of the patch(es) [77777777] in OH C:Hyperion
-----------------------------------------------------------------------------------
OPatch Session completed with warnings.

To copy all of the data in an aggregate storage application, you must merge all incremental data slices into the main database slice. Data in unmerged incremental data slices is not copied.

The following information updates the index cache size information in the Essbase 11.1.2.2.000 documentation.

Minimum value: 1 MB (1,048,576 bytes)

Maximum values:

32-bit Essbase: 4 GB

64-bit Essbase: 256 TB

Default values:

Buffered I/O: 1 MB

Direct I/O: 10 MB

The minimum and maximum values apply to buffered and direct I/O.

This topic replaces the topic named “Establishing a Connection to a Teradata Database when Using Essbase with OPMN” that appeared in a previous version of this Readme.

To configure Teradata as a data source:

1.Install Teradata drivers, which you must obtain from Teradata.

·Essbase Studio uses JDBC drivers. The JDBC Teradata driver must be installed on the computer on which Essbase Studio Server runs.

Essbase Studio uses the JDBC Teradata driver to deploy cubes in streaming mode.

To deploy cubes in non-streaming mode, the ODBC Teradata driver must be installed on the computer on which Essbase Server runs.

·Essbase uses ODBC drivers. The ODBC Teradata driver must be installed on the computer on which Essbase Server runs.

2.Stop Essbase from the Windows Services panel using the Oracle Process Manager and Notification (OPMN) service: EPM_epmsystem1.

3.Backup the OPMN configuration file (opmn.xml).

For example:

C:OracleMiddlewareuser_projectsepmsystem1configOPMNopmnopmn.xml

4.Open the opmn.xml file in a text editor.

5.To properly load the Teradata drivers, the opmn.xml file must include a statement that points to the location of the Teradata libraries.

a.Locate the following statement in the opmn.xml file:

<variable value='-Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration'/>

b. After this statement, add a statement similar to the following one:

<variable append='true' value='C:Program FilesTeradataClient14.00Shared ICU Libraries for Teradatalib'/>

6.When using Teradata data sources with Essbase, and using OPMN to monitor and control the Essbase Agent process, you must update the opmn.xml file with variables for the operating system you are using.

Note: The absolute path value cannot contain spaces. The examples of absolute path values are based on a 64-bit machine configuration.

64-bit Windows

Add these variables:

·TWB_ROOT: Teradata root

·PATH: Teradata shared libraries

·PATH: Teradata client DLL libraries

·PATH: Teradata Call-Level Interface Version 2 routines

·PATH: Teradata message DLL libraries

64-bit Windows example:

<variable value='C:PROGRA~1TeradataClient14.00'/>

<variable append='true' value='C:PROGRA~1TeradataClient14.00SHARED~1lib'/>

<variable append='true' value='C:PROGRA~1TeradataClient14.00TERADA~1bin64'/>

<variable append='true' value='C:PROGRA~1TeradataClient14.00CLIv2'/>

<variable append='true' value='C:PROGRA~1TeradataClient14.00TERADA~1msg64'/>

64-bit AIX

Add these variables:

·LIBPATH: Teradata ODBC libraries

·LIBPATH: Teradata shared libraries

·LIBPATH: ODBC components needed to load Teradata ODBC drivers

·LIBPATH: Teradata client libraries

·COPERR: Directory where the errmsg.txt file resides

·NLSPATH: Teradata message libraries

64-bit AIX example:

<variable append='true' value='/opt/teradata/client/ODBC_64/lib'/>

<variable append='true' value='/opt/teradata/client/13.10/tdicu/lib64'/>

<variable append='true' value='/usr/odbc/lib:/usr/odbc/drivers'/>

<variable append='true' value='/usr/lib:/usr/teragss/aix-power/client/lib'/>

<variable value='/usr/libperion/essbase'/>

<variable value='/opt/teradata/client/13.10/odbc_32/msg/%N'/>

<variable append='true' value='/usr/lib/nls/msg/%L/%N'/>

<variable append='true' value='/usr/lib/nls/msg/%L/%N.cat'/>

64-bit LINUX

Add these variables:

·TWB_ROOT: Teradata root

·TD_ICU_DATA: Teradata shared libraries

·NLSPATH: Teradata ODBC message libraries

·COPERR: Directory where the errmsg.txt file resides

·COPLIB: Directory where the libcliv2.so library file resides

·LD_LIBRARY_PATH: Teradata libraries

·PATH: Teradata client directories

Note: The errmsg.txt and libcliv2.so files typically reside in the same directory. Therefore, the value for the COPERR and COPLIB variables is typically identical.

64-bit LINUX example:

<variable value='/opt/teradata/client/13.10/tbuild'/>

<variable value='</opt/teradata/client/13.10/tdicu/lib64> '/>

<variable value='</opt/teradata/client/13.10/odbc_64/msg/%N > '/>

<variable append=”true” id=”NLSPATH” value=”/opt/teradata/client/13.10/tbuild/msg64/%N”/>

<variable value='/usr/lib64'/>

<variable value='/usr/lib64'/>

<variable append=”true” id=”LD_LIBRARY_PATH” value=”/opt/teradata/client/13.10/tbuild/lib64”/>

<variable append=”true” id=”LD_LIBRARY_PATH” value=”/usr/lib64”/>

<variable append=”true” id=”PATH” value=”/opt/teradata/client/13.10/tbuild/bin”/>

<variable append=”true” id=”PATH” value=”/opt/teradata/client/13.10/tbuild/lib64”/>

7.Save the opmn.xml file.

8.Start Essbase from the Windows Services panel using the Oracle Process Manager and Notification (OPMN) service (EPM_epmsystem1).

9. Verify the following:

·Essbase: Use the Data Prep Editor in Essbase Administration Services Console to connect to a Teradata database using a DNS.

·Essbase Studio: Perform a cube deployment in non-streaming mode, which uses the Teradata ODBC driver.

See the description of defect 13404757 in the 'Known Issues' section of this Readme.

If you have installed Oracle Database 11g Release 2 (11.2.0.1.0), the AIX 5.3 kernel extensions update file (rootpre.sh) is included. Or you can obtain the file from the Oracle Software Delivery Cloud site.

1.Log into Oracle Software Delivery Cloud at:

2.On the “Media Pack Search” page, enter the following information:

·For Select a Product Pack, select Oracle Database.

·For Platform, select IBM AIX on POWER Systems (64-bit).

3.Click Go.

4.In the results list, select Oracle® Database 11g Release 2 (11.2.0.1.0) Media Pack for IBM AIX on POWER Systems (64-bit), and then click Continue.

5.On the “Oracle® Database 11g Release 2 (11.2.0.1.0) Media Pack for IBM AIX on POWER Systems (64-bit)” page, click Download next to Oracle Database 11g Release 2 (11.2.0.1.0) for IBM AIX on POWER Systems (64-bit) (Part 1 of 2).

6.Unarchive the download file.

7.Run the rootpre.sh file on the computers on which Essbase Server and Essbase client are installed.

The following information updates the Red Hat Linux information in the 'Using Teradata Data Sources' topic in the Oracle Essbase SQL Interface Guide:

Essbase supports Teradata Parallel Transporter (TPT) 12 with the Teradata 12 ODBC driver on 32-bit and 64-bit Red Hat Linux platforms.

To configure Essbase for encrypted (SSL) communication with Provider Services, you must perform a configuration task to enable the Essbase libcurl library to set up a secure channel to Provider Services. This is required to enable secure connections to be made between Essbase and Provider Services using logical Essbase cluster names.

Use the following three configuration options to either disable peer verification, or provide the location of the certificate authority (CA) certificates. To complete this configuration, set the following environment variables, using the operating system command line:

API_DISABLE_PEER_VERIFICATION=1

Set this variable if the connection goes through SSL, but does not need a certificate. Essbase provides data encryption, but not authentication.

If API_DISABLE_PEER_VERFICATION is not set, or is set to 0, you must set up a certificate. To establish a secure connection with Provider Services, Essbase requires a CA signing of a Provider Services certificate, to provide authentication for the Provider Services server. You can specify either a file or a directory which includes the certificate. Choose one of the following options:

API_CAINFO=CA certificate file path

or

API_CAPATH=directory path containing CA certificates

The environment variables described are only applied when logging with a Provider Services URL that starts with https. Logins with the http URL are directed through TCP/IP.

The SECFILEBACKUPINTERVAL configuration setting topic in the Oracle Essbase Technical Reference incorrectly states the description of the n argument. The following information is correct:

SECFILEBACKUPINTERVAL n

n—Specifies the amount of time in seconds.

The default value is 300 seconds (which is five minutes). A value of 0 means that the essbase.sec file will not be backed up. Other than 0, the value cannot be less than 300.

(13932483) A new Essbase.cfg setting, MDXQRYGOVCOUNT, is added as a query governor (along with the existing configuration settings, QRYGOVEXECTIME and QRYGOVEXECBLK) to help you limitations set on MDX queries.

MDXQRYGOVCOUNT

Initializes a counter (number of check conditions) to control how often Essbase checks for conditions that would warrant termination of an MDX query. Using this counter can reduce or increase the default number of checks (1000); reducing the number of checks (by setting n higher) improves performance. The counter starts at n and decrements until the counter reaches zero: at that time Essbase performs a check.

Syntax

MDXQRYGOVCOUNT [appname [dbname]] n

·appname —Optional. Applies the checking counter to the application specified. If you specify appname, you must also specify a value for n, or Essbase Server ignores this setting. If you do not specify an application, then you cannot specify a database, and the counter applies to all applications and databases on Essbase Server. If you specify a value for appname and do not specify a value for dbname, the counter applies to all databases in the specified application.

Install Essbase Client On Linux Download

·dbname —Optional. Must be used with appname and n, or Essbase Server ignores this setting. If you specify dbname, appname, and n, the counter is applied only to the specified database.

·n —Integer specifying the counter (number of check conditions) that Essbase Server checks for conditions that warrant query termination. You must specify this parameter or Essbase Server ignores this setting. If do not specify appname or dbname, the counter applies to the entire server. The default value is 1000. The minimum value is 100, and the maximum value is 5000.

Notes

You can use the Esc key to cancel any query running from MaxL Shell.

Example

MDXQRYGOVCOUNT 1500

The following description of the AGENTTHREADS configuration setting is more accurate than the topic in the Oracle Essbase Technical Reference.

AGENTTHREADS

Specifies the maximum number of threads that the Agent process (ESSBASE) can spawn. Agent threads are used for logging in and out of Essbase Server, starting and stopping an application, etc.

One agent thread is used in conjunction with a thread spawned by the AGTSVRCONNECTIONS configuration setting to allow the initial login through the Agent and to establish the first connection to an application and database. When a connection is requested, the Agent assigns a thread to the request and releases the thread when the connection is made.

Essbase Client Install

The rest of the agent threads are used for other Agent tasks unrelated to AGTSVRCONNECTIONS. Once connected, AGTSVRCONNECTIONS threads are no longer used. Client requests are managed by threads spawned by the application process (ESSSVR).

Syntax

AGENTTHREADS n

n: Specifies the number of threads that the Agent process (ESSBASE) can spawn.

·32-bit platform: 2 to 500, inclusive

·64-bit platform: 2 and 1024, inclusive

The default value is 5.

Notes

·Oracle strongly recommends that you use the default value when running Essbase on a 32-bit platform.

·While the actual maximum value you can set is 500 (32-bit platform) or 1024 (64-bit platform), the maximum number of threads an operating system can handle might be much lower. Before specifying a value greater than the default value, check with your system administrator, as higher values can significantly consume system resources.

·If you specify a number less than 2, over the maximum, or a decimal value, Essbase overrides the value with a closely approximate value of its own.

·One thread is required for each initial connection to an application and database.

Example

AGENTTHREADS 15

The following description of the AGTSVRCONNECTIONS configuration setting is more accurate than the topic in the Oracle Essbase Technical Reference.

AGTSVRCONNECTIONS

Specifies the maximum number of threads that Essbase can spawn to allow the first connection to an application and database, negotiated between the Agent process (ESSBASE) and application process (ESSSVR). AGTSVRCONNECTIONS threads make the Agent process (ESSBASE) communicate with the application process (ESSSVR).

Each AGTSVRCONNECTIONS thread uses one Agent process (ESSBASE) thread only while logging in and connecting to an application and database. Once connected, client requests are managed by threads spawned by the application process (ESSSVR).

Syntax

AGTSVRCONNECTIONS n

n: Specifies the maximum number of AGTSVRCONNECTIONS threads that Essbase can spawn.

·Default value: 5

·Minimum value: 1

Caution! Oracle recommends a maximum value of 10.

Notes

·Make sure you have enough open file descriptors configured in the operating system to accommodate the value you set for AGTSVRCONNECTIONS.

·Consider specifying a value greater than the default value, if you are expecting a large number of users to login and select the same application within a short period of time.

Example

AGTSVRCONNECTIONS 7

Sets the maximum number of AGTSVRCONNECTIONS threads that Essbase can spawn to 7.

The following description of the SERVERTHREADS configuration setting is more accurate than the topic in the Oracle Essbase Technical Reference.

SERVERTHREADS

Overrides the default value of the number of threads that the application process (ESSSVR) can spawn. Application threads are used in calculations, client requires, administrative activities, etc.

When a transaction is requested, the application process (ESSSVR) assigns a thread to the transaction and releases the thread when the transaction is completed.

Syntax

SERVERTHREADS [appname] n

·appname—Optional. Specifies an application; the SERVERTHREADS setting applies to all databases within the named application.

If you do not specify an application, the setting applies to all applications and databases on Essbase Server.

·n—Specifies the number of threads that the application process (ESSSVR) can spawn.

·32-bit platform: 20 to 500, inclusive

·64-bit platform: 20 to 1024, inclusive

The default value is 20.

If you specify a value that is:

·Less than the minimum, Essbase interprets the value as 20

·Greater than the maximum, Oracle Essbase interprets the value as 500 (32-bit platform) or 1024 (64-bit platform)

Notes

·While the actual maximum value you can set is 500 (32-bit platform) or 1024 (64-bit platform), the maximum number of threads an operating system can handle might be much lower. Before specifying a value greater than the default value, check with your system administrator, as higher values can significantly consume system resources.

·If the computer on which Essbase Server runs freezes while running multiple reports simultaneously, increase the value of SERVERTHREADS by one for each report you run.

·Each application thread may create child threads for tasks such as parallel calculation, parallel data load or export, and parallel restructuring. If the total number of running threads is too high, threads may lose efficiency in contending for server resources. To manage thread contention, use the MAXTOTALACTIVETRANSACTIONS and MAXACTIVEUPDATETRANSACTIONS settings.

Example

SERVERTHREADS 25

Allows all applications on Essbase Server to spawn up to 25 threads.

SERVERTHREADS Sample 100

Allows the Sample application on Essbase Server to spawn up to 100 threads.

Copyright © 2012, Oracle and/or its affiliates. All rights reserved.
http://www.oracle.com