CPU % Util spikes during single insert

From: Sean McMurray <smcmurray_at_acad.utah.edu>
Date: Fri, 14 Jan 2000 15:52:46 -0800
Message-ID: <387FB6CE.41027C5C@acad.utah.edu>

I'm experiencing a problem with an application where selects and inserts work fine on all tables except one.

Inserting to a similar table is instant, but inserting a single record to the problem table causes CPU %Util to spike from 0% to 100%; Mem % Util jumps from 0% to 7.4%; and it takes 4+ minutes to complete the insert!

The table structure is:

NUMBER

VARCHAR2(8)
VARCHAR2(32)
VARCHAR2(32)
VARCHAR2(32)

DATE

VARCHAR2(128)
VARCHAR2(128)
VARCHAR2(128)
VARCHAR2(64)
VARCHAR2(2)
VARCHAR2(9)
VARCHAR2(64)
VARCHAR2(64)
VARCHAR2(24)
VARCHAR2(24)
VARCHAR2(128)
VARCHAR2(1)
VARCHAR2(1024)
VARCHAR2(1024)

There are <10,000 records in the table.

Inserting into a table with an even larger structure is instant. Inserting into tables with 250,000+ records is instant.

Any hints on what the problem might be?

Sean McMurray Received on Fri Jan 14 2000 - 17:52:46 CST