Re: Oracle performance degradation - help!?!

From: Jacob Steen Due <jcd_at_ramboll.dk>
Date: 1997/02/11
Message-ID: <33001B41.2F7D@ramboll.dk>#1/1

Michael Wilson wrote:
>
> 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

Check if there is a problem with latches - we have experienced some performance improvement by operating on a database with larger blocksizes - apparently this causes fewer latches on the index-structures
involved.

Also check if there are indexes which can be removed during conversion and restored later - this improves performance too (sometimes quite much).

/jacob  

---

Jacob Steen Due						   email: jcd_at_ramboll.dk
Oracle DBA and application developer                         web:

www.ramboll.dk
RAMBOLL
Teknikerbyen 19
DK-2830 Denmark Received on Tue Feb 11 1997 - 00:00:00 CST