Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CPU % Util spikes during single insert
XU8 wrote:
>
> 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
> >
> >
Are there any triggers on the table ?
--
"Some days you're the pigeon, and some days you're the statue." Received on Mon Jan 17 2000 - 05:29:10 CST