all data steps reading data from the “dat” library would use four threads:
libname dat oracle schema=dat_owner user=testuser pw=XXXXXXXX path=datdbp dbsliceparm=(ALL,4);
You can also use the DBSLICEPARM option on only selected data steps, rather than on the LIBNAME statement, as this example shows:
libname dat oracle schema=dat_owner user=testuser pw=XXXXXXXX path=datdbp;
day between '01JAN2006:00:00:00'dt and '30MAY2006:00:00:00'dt ));
Read the case-study below...