Job Startup Time taking too long

sravanthi · Post by **sravanthi** » Mon Mar 29, 2010 10:43 am

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

ArndW · Post by **ArndW** » Mon Mar 29, 2010 11:00 am

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.

sravanthi · Post by **sravanthi** » Mon Mar 29, 2010 12:10 pm

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!

ray.wurlod · Post by **ray.wurlod** » Mon Mar 29, 2010 1:35 pm

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