Show TOC

RV_MAX_ACTIVE_SUBFRAGMENT_COUNT OptionLocate this document in the navigation structure

This value maximizes utilization of the number of cores on the machine.

Allowed Values

>=0

Default
0
Note Use of any value other than the default is not recommended as it could negatively impact CPU utilization and scalability of bulk loads.
Scope

Option can be set at the database (PUBLIC) level only.

Requires the SET ANY SYSTEM OPTION system privilege to set this option. This option takes effect on a table with the first write operation on the table. If the value of this option is changed after the first write operation has occurred, the new value does not take effect on the table until after a restart of the server.

Remarks

If the value is set to anything other than the default, the system uses the specified value or the total number of cores on the machine, whichever is less.