hi @chinedukoggu,
On question one, yes. max_records_returned governs the max number of records, so this should work. It’s possible that there’s an issue with Oracle. We’ll take a look. If there’s an issue we’ll ship a fix in the next sprint.
On question two, you can use the limit parameter together with the offset parameter to fetch 1000 records at a time. It’s a good policy to batch the number of records coming back to the client application. There’s a short tutorial here https://wiki.dreamfactory.com/DreamFactory/Tutorials/Paginating_with_limits_and_offsets.