Some Common Errors - 4 - Not using ARRAYSIZE

When fetching large datasets from the database server to a client (even if the client is sqlplus running on the same host machine) it becomes important to use the right ARRAYSIZE.

I have blogged about this frequently, so rather than creating another test case, I post links to my previous blogs :

Using ARRAYSIZE to reduce RoundTrips and number of FETCH calls

Tuning Very Large SELECTs in SQLPlus

Array Processing, SQL*Net RoundTrips and consistent gets

(Note : The default ARRAYSIZE in Oracle's SQLPlus client is 15).

.

.

.