RESTRUCTURETHREADS

The RESTRUCTURETHREADS configuration setting lets you enable parallel restructuring for an Essbase cube, and to specify the number of threads to use.

RESTRUCTURETHREADS configuration applies only to block storage (BSO) databases, and does not apply to aggregate storage (ASO) databases.

Syntax

RESTRUCTURETHREADS [ appname [ dbname] ] n

appname—Application name. Optional parameter for enabling parallel restructuring for one or all cubes in an application.
dbname—Database (cube) name. Optional parameter for enabling parallel restructuring for an individual cube. This parameter must be used in combination with appname.
n—Number of threads to use in parallel restructuring. The default is 1.

Notes

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

RESTRUCTURETHREADS xxxxx Basic 2

enables parallel restructuring for any application with a Basic cube.
Settings for nonexistent applications or cubes are ignored.
Oracle recommends setting an application’s RESTRUCTURETHREADS to 2 for most systems (with a maximum of 4), or 4 if the application runs on Exalytics (maximum of 8). Check your calculation and restructure performance after making any changes.

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