Set the value of the QUERY_ROWS_RETURNED_LIMIT option to prevent the optimizer from rejecting
queries with large result sets.
The
QUERY_ROWS_RETURNED_LIMIT option
tells the query optimizer to reject queries that might otherwise
consume too many resources. If the query optimizer estimates that
the result set from a query will exceed the value of this option,
it rejects the query with the message:
Query rejected because it exceed resource: Query_Rows_Returned_Limit
Set this option only to reject queries that consume vast resources.