data access from Oracle - performance issues

Reply
Occasional Contributor
Posts: 16

data access from Oracle - performance issues

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
Super Contributor
Super Contributor
Posts: 3,174

Re: data access from Oracle - performance issues

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.
Occasional Contributor
Posts: 11

Re: data access from Oracle - performance issues

> 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?
Ask a Question
Discussion stats
  • 2 replies
  • 395 views
  • 0 likes
  • 3 in conversation