Re: Oracle performance degradation - help!?!

I concur with the latch therory. Check v$session_wait and see exactly what sessions are waiting on.

select event, sum(1) from v$session_wait group by event;

Russ

Jacob Steen Due <jcd_at_ramboll.dk> wrote:

>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 Wed Feb 12 1997 - 00:00:00 CST