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
Job Startup Time taking too long
Moderators: chulett, rschirm, roy
Job Startup Time taking too long
sravanthi
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Hi ArndW,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. ...
It is taking 4 min on data base side.Okay looks like it is data base problem and not DS.
Thanks!
sravanthi
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: