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

Top 10 Possibilities...When Batch Processes Attack!

1. Oracle Trace facility enabled by default
2. Using count(*) to see if the row exists and determine whether you need to do an insert or update
3. Excessive logins to the database (ie, a logon for every row in a file being processed--note: this further aggravates #10)
4. Logging...too much, too often
5. Unindexed foreign keys (not necessarily a factor in all versions of Oracle)
6. Statistics/indexes stagnating too quickly
7. The devil (or any powerful evil entity of your choice) is stealing resources from my box to run his DSS that tracks the "evil that men do"
8. Non-optimal SQL in the batch processes
9. Excessive parsing (use those *&$@#! bind variables)
10. You've gone a little overboard on the denormalization (note: this further aggravates #2-10)

FINAL NOTE: These are all from past personal experience (even though #4 can be loosely interpreted as "evil developers running their applications on my database server)...experiences may vary. :)

Jeffery Stevenson
Chief Database Geek
Medical Present Value, Inc.
Austin, TX

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Dan.Hubler_at_midata.com
Sent: Monday, August 28, 2000 4: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).