DSXchange

Hi,

We have server job which is reading from Oracle 10g and doing a join with hash file and writing to hash file.

The job is taking more than 5 min to start reading rows from oracle.

The job waits for 5 min and then starts reading and rows/sec is also small.We have 10 milion records and this job is taking 40 min to complete.

Please advice!

Thanks

If you execute the exact same SELECT statement from your favorite DB access tool, how long does that take? Odds are high that this lengthy period isn't related to DS but to the database.

ArndW wrote:If you execute the exact same SELECT statement from your favorite DB access tool, how long does that take? Odds are high that this lengthy period isn't related to DS but to the database. ...

Hi ArndW,

It is taking 4 min on data base side.Okay looks like it is data base problem and not DS.

Thanks!

Does the SELECT statement include any blocking operation, such as GROUP BY, DISTINCT or ORDER BY?