Hi Gurus,
My source database is Oracle and one of the source query executed in 1 min in TOAD(Database tool) and that same query i putted in source oracle stage (job level) then for the extraction of data is taking nearly 50 mins.
I am getting what may be the problem for this,
can any one provide the needful information on this
Thanks in Advance...
Query taking much time...
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 24
- Joined: Wed Mar 19, 2008 1:13 am
Query taking much time...
M.BALAJI
-
- Participant
- Posts: 24
- Joined: Mon Jul 12, 2004 10:16 am
Re: Query taking much time...
In Toad, the system does not wait for fetching all rows. It bring only few rows to the answer window and while scrolling down the remaining rows are fetched. If you have millions of rows you may get the resultset with in seconds or few minutes, but it doesn't mean that all rows are fetched. So check the time consuming at TOAD for all rows and compare the same with DATASTAGE. On certain occasion if the job is PX, it may wait for minutes to get the available node for fetching the data.
-
- Participant
- Posts: 24
- Joined: Wed Mar 19, 2008 1:13 am
-
- Participant
- Posts: 24
- Joined: Wed Mar 19, 2008 1:13 am