Oracle performance degradation - help!?!

From: Michael Wilson <MWilson_at_ti.com>
Date: 1997/02/10
Message-ID: <5dob3v$iac@sf18.dseg.ti.com>#1/1

We have a purchased software package that includes "batch" programs for the conversion of data from our old system to the new one. We are running on an HP-UX 10.01 system, 1GB memory, 2 processors with Oracle 7.1.4. When the batch program starts, we see insert rates of 500/minute which quickly degrades after 3-4 hours to 20 inserts/minute. The supplier says that they are committing after every insert. Looking at USER_EXTENTS shows no extents on the table involved. Any ideas or recommendations would be appreciated.

TIA,
  Michael

---

  Michael Wilson                     _/_/_/_/_/   _/_/_/
  SG Software Solutions                 _/         _/
  Defense Systems & Electronics        _/         _/
  Texas Instruments, Inc.             _/         _/
                                     _/       _/_/_/

  mwilson_at_ti.com ** 972-575-3448 ** 972-575-2628 (fax)

---

Received on Mon Feb 10 1997 - 00:00:00 CST