RE: Slower and slower and slower and............................

From: Bowes, Chris <Chris.Bowes_at_kosa.com>
Date: Mon, 28 Aug 2000 17:09:12 -0400
Message-Id: <10602.115685@fatcity.com>

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_at_Kosa.com

-----Original Message-----

From: Dan.Hubler_at_midata.com [mailto:Dan.Hubler_at_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_at_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_at_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"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>RE: Slower and slower and slower and............................</TITLE>
</HEAD>
<BODY>

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

<P><FONT SIZE=2>--Chris</FONT>
<BR><FONT SIZE=2>Chris.Bowes_at_Kosa.com</FONT>
</P>
<BR>

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Dan.Hubler_at_midata.com [<A HREF="mailto:Dan.Hubler_at_midata.com">mailto:Dan.Hubler_at_midata.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Monday, August 28, 2000 5:44 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: Slower and slower and slower and............................</FONT>
</P>

<P><FONT SIZE=2>Oracle 7.3.4.4&nbsp; on NT v4.0</FONT>
<BR><FONT SIZE=2>===================</FONT>
</P>

<P><FONT SIZE=2>Running a series of batch-type jobs that populate a certain bunch of tables</FONT>

in the DB.

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

<P><FONT SIZE=2>Any ideas as to why?</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: </FONT>

INET: Dan.Hubler_at_midata.com

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

Received on Mon Aug 28 2000 - 16:09:12 CDT