Hi

The array size is dependent upon the tool..i am not aware of oracle apps..but for

sqlplus the default is 15
JDBC the defualt is 10
Pro*c the default is 2
OCI it is 1

you know what even if your server memory is unlimited and you have an unlimited sga and assuming oracle stored the 2 million rows for you in the SGA then..you need to have all clients with unlimited memory tooo..:-D which i guess is impossible :-D

if you are sorting these 2 Million record then oracle will materialize this sort in the temp tablespace..you make sure you have a large temporary tablespace..

regards
Hrishy