Specifies a threshold for determining whether bulk operations are used to process qualifying Select queries that include a Top n clause. (See Bulk operations for more information on qualifying Select queries.)
Valid Values
x
where
x
is a positive integer greater than 0.
Behavior
If x is less than or equal n (the number of rows specified in the Top n clause), the standard mechanism is used to process the query.
If x is greater than n (the number of rows specified in the Top n clause), bulk load is used to process the qualifying queries.
Notes
Oracle Eloqua automatically clears out the bulk staging area after this timeout, so if the query is large and the data takes more than this time to run, the query could be aborted midstream.
