There is nothing you need to set to make DBI read all the records. Are you positive that your query returns more records when run from the Oracle shell? If so, you may have a bug in your code. If you show us the code, we can probably tell you.