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.
RESTRUCTURETHREADS [ appname [ dbname] ] n
appname—Application name. Optional parameter for enabling parallel restructuring for one or all databases in an application. This parameter may be used in combination with dbname. If you omit appname, you cannot specify dbname, and RESTRUCTURETHREADS will be enabled for all applications and databases. See Example below.
dbname—Database name. Optional parameter for enabling parallel restructuring for an individual database. This parameter must be used in combination with appname. If you specify dbname, you must also specify appname. See Examples below.
n—Number of threads to use in parallel restructuring.
Use the value xxxxx to indicate "all" for any application or database argument. For example:
RESTRUCTURETHREADS xxxxx Basic 8
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.
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, for all databases in an application, or for all databases on a server. For more information about parallel restructuring, see the Oracle Essbase Database Administrator's Guide.
RESTRUCTURETHREADS 8
Specifies eight threads and applies to the entire server
RESTRUCTURETHREADS Sample 8
Specifies eight threads and applies to all databases in the Sample application
RESTRUCTURETHREADS Sample Basic 8
Specifies eight threads and applies to the Basic database in the Sample application