__dbf_set
Sets vector execution parameters.
__dbf_set
(in flag_name varchar,
outflag_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
Set the maximum number of outstanding parallel work units to 16:
SQL> __dbf_set ('enable_qp', 16);