A Mutithreading case study with SAS that reads large amounts of data from
Oracle databases.
DBSLICEPARM option in SAS Access greatly improves the speed of reading data from Oracle...
For Example
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;
data lll;
set dat.disc_lll_v
(dbsliceparm=ALL
keep=day
hour
price
most_recent
where=(most_recent='Yes' and
day between '01JAN2006:00:00:00'dt and '30MAY2006:00:00:00'dt ));
run;
Read the case-study below...
