Message-Id: <10602.115685@fatcity.com> From: "Bowes, Chris" Date: Mon, 28 Aug 2000 17:09:12 -0400 Subject: RE: Slower and slower and slower and............................ This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C01134.36DE2A78 Content-Type: text/plain; charset="iso-8859-1" Could be some full table scans in the jobs. The more records added, the longer it would take. --Chris Chris.Bowes@Kosa.com -----Original Message----- From: Dan.Hubler@midata.com [mailto:Dan.Hubler@midata.com] Sent: Monday, August 28, 2000 5:44 PM To: Multiple recipients of list ORACLE-L Subject: Slower and slower and slower and............................ Oracle 7.3.4.4 on NT v4.0 =================== Running a series of batch-type jobs that populate a certain bunch of tables in the DB. Seem to run slower and slower as more and more records are input. Any ideas as to why? -- Author: INET: Dan.Hubler@midata.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C01134.36DE2A78 Content-Type: text/html; charset="iso-8859-1" RE: Slower and slower and slower and............................

Could be some full table scans in the jobs.  The more records added, the longer it would take.

--Chris
Chris.Bowes@Kosa.com


-----Original Message-----
From: Dan.Hubler@midata.com [mailto:Dan.Hubler@midata.com]
Sent: Monday, August 28, 2000 5:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Slower and slower and slower and............................



Oracle 7.3.4.4  on NT v4.0
===================

Running a series of batch-type jobs that populate a certain bunch of tables
in the DB.

Seem to run slower and slower as more and more records are input.

Any ideas as to why?



--
Author:
  INET: Dan.Hubler@midata.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).