Prev Up Next
ltrim Home stat_import

Name

__dbf_set — Sets vector execution parameters.

Synopsis

__dbf_set ( in flag_name varchar ,
out flag_value any );

Description

Sets at run time by a dba group user the vector execution parameters.

Parameters

flag_name

Name of the flag.

For Configuring Vectored Execution, should be used the following values:

Note: Only effective with Virtuoso 7.0 and later.

  • dc_batch_sz : flag for ini parameter VectorSize;

  • dc_max_batch_sz : flag for ini parameter MaxVectorSize;

  • enable_dyn_batch_sz : flag for ini parameter AdjustVectorSize;

  • enable_qp : flag for ini parameter ThreadsPerQuery;

  • aq_max_threads : flag for ini parameter AsyncQueueMaxThreads;

flag_value

Value of the flag.

Examples

Example24.212.Simple Use

Set the maximum number of outstanding parallel work units to 16:

SQL> __dbf_set ('enable_qp', 16);

Prev Up Next
ltrim Home stat_import