data access from Oracle - performance issues

[4john]

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

[sbb]

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.

[MZunnurain]

> 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?