Re: CPU % Util spikes during single insert

Sean McMurray wrote:

> 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

Some things you might want to try:

    If you are running with the Cost Based Optimizer has the table and its indexes been analyzed recently?

    Have you tested for data corruption of the table by either exporting or doing an analyze validate?

    Have you tried dropping and recreating the indexes?

    Have you done an Explain Plan on the SQL that is doing the update?

    Does another SQL have the table locked when you are trying to update?

hth

--
Jerry Gitomer
Once I learned how to spell DBA, I became one. Received on Sat Jan 15 2000 - 00:08:31 CST