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
Example 24.212. Simple Use
Set the maximum number of outstanding parallel work units to 16:
SQL> __dbf_set ('enable_qp', 16);