Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CPU % Util spikes during single insert
How many indexes do you have on the table ?
The more indexes, the longer the insert will take.
Sean McMurray wrote in message <387FB6CE.41027C5C_at_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 Sun Jan 16 2000 - 20:17:55 CST