Specifies the maximum number of rows to be fetched from Activity_XXX tables in a single request.
Valid Values
x
where
x
is a positive integer between 2 and 50000.
Notes
Generally, higher page sizes return results more quickly. However, Oracle Eloqua imposes a 32 MB limit on response package size. If queries return large records, too many records within a single page will exceed that limit, causing the query to fail.
All of the objects returned within a page must be materialized as the page is retrieved, so sufficient Java heap space is necessary with large page sizes containing many small columns.
Generally, higher page sizes return results more quickly. However, Oracle Eloqua imposes a 32 MB limit on response package size. If queries return large records, too many records within a single page will exceed that limit, causing the query to fail.