| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Slower and slower and slower and............................
do you have indexes on the tables being populated? When you add data, the
indexes get updated every time you add a row. As the size of the tables (and
indexes) grows, the time to insert the row into the index increases and your
jobs will slow down.
This is the reason many DBAs will drop indexes before doing imports and then recreate them afterwards.
If this is at all possible for the jobs you are running, I would suggest trying it.
Rachel
>From: Dan.Hubler_at_midata.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Slower and slower and slower and............................
>Date: Mon, 28 Aug 2000 13:44:24 -0800
>
>
>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).
Share information about yourself, create your own public profile at Received on Mon Aug 28 2000 - 16:47:19 CDT
 |
 |