Page 1 of 1

performance problem in 8.1 server job

Posted: Wed Sep 15, 2010 4:41 am
by daramanoj
Hi

I am trying to extract data from oracle table which is a very high volume
so i am confused with the array size value to be and actually ithe problem is the rows per sec is decreasing as the job is running further and it takesa lot of time to finish the job.

Can any one help me out in this

Re: performance problem in 8.1 server job

Posted: Wed Sep 15, 2010 5:44 am
by HariK
What are you doing with all the data that has been extracted? post more information about the job design.

Re: performance problem in 8.1 server job

Posted: Wed Sep 15, 2010 6:15 am
by sultan@cts
let us know the arraysize value?

Posted: Wed Sep 15, 2010 6:41 am
by chulett
More about your job design and what is going on in your target than your source query, I would wager. As noted, details would be appreciated.