topic Re: data access from Oracle - performance issues in SAS Health and Life Sciences

data access from Oracle - performance issues

4john — Tue, 13 Jul 2010 20:29:15 GMT

I am accessing 2-3 million records from Oracle into SAS which is taking 4-5 hrs.Is there a way to increase the performance and reduce time.I guess,DB load and server load are causing this scenario.
It takes 3.5hrs real time and 6min cpu time.
Any suggestion would be great.

Thanks,
John

Re: data access from Oracle - performance issues

sbb — Tue, 13 Jul 2010 20:35:44 GMT

Share your SAS code used to access Oracle - also have you checked the SAS.COM support website for reference documents and supporting conference SUGI/SGF technical papers on the topic?

Scott Barry
SBBWorks, Inc.

Re: data access from Oracle - performance issues

MZunnurain — Tue, 13 Jul 2010 20:47:00 GMT

> Share your SAS code used to access Oracle - also have
> you checked the SAS.COM support website for reference
> documents and supporting conference SUGI/SGF
> technical papers on the topic?
>
> Scott Barry
> SBBWorks, Inc.

I agree with Scott Barry, a sample of code would be helpful. Are you pulling down any information that is not needed, exclude those columns you don't need. Are you doing any complicated calculations? Conversions? Simplify them. Are there any space issues where the destination files are going? Do you have the fastest possible speed set? Is there a smaller table with the same columns that you could use for testing?