Why the Job time become longer and longe

#1

I use DTS to import data from Oracle,In begining ,it's work's perfect.But the Job time became longer and longer day by day. I asking my boss,he says that Oracle Server is idle in that time.
And we do not change any other settings.Would you tell me what wrong is it?
Thanks for your suggest.

#2

Anything going on at the same time ?
Data transfer larger ?
Locks/Blocks?
Is the increase in time linear ?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Arron" <9144492 (AT) pchome (DOT) com.tw> wrote

Quote:

I use DTS to import data from Oracle,In begining ,it's work's perfect.But
the Job time became longer and longer day by day. I asking my boss,he says

that Oracle Server is idle in that time.

Quote:

And we do not change any other settings.Would you tell me what wrong is
it?
Thanks for your suggest.

#3

1.No other process going at the same time on SQL and Qracle
2.No.The RowCount during transfer almost the same.
3.No.The process is going on in the early morning.So I
think there are no dead lock on time.And after I go to
work,I do not see any dead lock messages.
4.Not always increase in time linear , but almost.
ex: 0:37 -->0:34 -->1:59-->1:51-->2:17-->1:50-->2:26
What's wrong with my SQL job?
Help~~~
================================================== =========
================================================== =========

Quote:

-----Original Message-----
Anything going on at the same time ?
Data transfer larger ?
Locks/Blocks?
Is the increase in time linear ?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Arron" <9144492 (AT) pchome (DOT) com.tw> wrote in message
news:7C6BDF16-206D-44FA-BEF1-40A876F5E73C (AT) microsoft (DOT) com...
I use DTS to import data from Oracle,In begining ,it's
work's perfect.But
the Job time became longer and longer day by day. I
asking my boss,he says
that Oracle Server is idle in that time.
And we do not change any other settings.Would you tell
me what wrong is
it?
Thanks for your suggest.

.

#4

Anything changed?

Is it faster when you execute it manually ?

A lot of people like to export to text file and then import the text file on
the other RDBMS when moving data between Oracle and SQL Server.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Arron" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

1.No other process going at the same time on SQL and Qracle
2.No.The RowCount during transfer almost the same.
3.No.The process is going on in the early morning.So I
think there are no dead lock on time.And after I go to
work,I do not see any dead lock messages.
4.Not always increase in time linear , but almost.
ex: 0:37 -->0:34 -->1:59-->1:51-->2:17-->1:50-->2:26
What's wrong with my SQL job?
Help~~~
================================================== =========
================================================== =========
-----Original Message-----
Anything going on at the same time ?
Data transfer larger ?
Locks/Blocks?
Is the increase in time linear ?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Arron" <9144492 (AT) pchome (DOT) com.tw> wrote in message
news:7C6BDF16-206D-44FA-BEF1-40A876F5E73C (AT) microsoft (DOT) com...
I use DTS to import data from Oracle,In begining ,it's
work's perfect.But
the Job time became longer and longer day by day. I
asking my boss,he says
that Oracle Server is idle in that time.
And we do not change any other settings.Would you tell
me what wrong is
it?
Thanks for your suggest.

.

#5

After my check,Nothing is changed.

#6

Then unfortunately I do not know.

What happens if you create a completely new job that does the exact same
thing as the current? This work any faster?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Arron" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

After my check,Nothing is changed.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Why the Job time become longer and longe

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Why the Job time become longer and longe - 11-09-2003 , 07:16 PM

Re: Why the Job time become longer and longe - 11-09-2003 , 07:41 PM

Re: Why the Job time become longer and longe - 11-10-2003 , 03:37 AM

Re: Why the Job time become longer and longe - 11-10-2003 , 09:32 AM

Re: Why the Job time become longer and longe - 11-10-2003 , 06:48 PM

Re: Why the Job time become longer and longe - 11-11-2003 , 04:26 AM