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

RESTRUCTURETHREADS

Specifies whether parallel restructuring is enabled for a database and the number of threads to use.

This setting does not apply to aggregate storage databases.

Syntax

RESTRUCTURETHREADS [ appname [ dbname] ] n

  • appname—Application name. Optional parameter for enabling parallel restructuring for one or all databases in an application.

  • dbname—Database name. Optional parameter for enabling parallel restructuring for an individual database. This parameter must be used in combination with appname.

  • n—Number of threads to use in parallel restructuring.

Notes

  • Use the value xxxxx to indicate "all" for any application or database argument. For example:

    RESTRUCTURETHREADS xxxxx Basic 2

    enables parallel restructuring for any application with a Basic database.

  • Settings for nonexistent applications or databases are ignored.

  • If RESTRUCTURETHREADS is not defined, the default is one thread.

  • Oracle recommends setting an application’s RESTRUCTURETHREADS to 2 for most systems, or 4 if the application runs on Exalytics. Check your calculation and restructure performance after making any changes.

Description

This setting specifies whether parallel restructuring is enabled for a database and the number of threads to use. You can enable parallel restructuring for individual databases, or for all databases in an application. For more information about parallel restructuring, see Parallel Restructuring in Designing and Maintaining Essbase Cubes.

Examples

RESTRUCTURETHREADS Sample 2

Specifies two threads and applies to all databases in the Sample application

RESTRUCTURETHREADS Sample Basic 4

Specifies four threads and applies to the Basic database in the Sample application