Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CPU % Util spikes during single insert

Re: CPU % Util spikes during single insert

From: Keith Jamieson <jamiesonk_at_phoenix.ie>
Date: Wed, 19 Jan 2000 16:23:25 -0000
Message-ID: <864ogl$kto$1@kermit.esat.net>


I recently had a problem where an update took ages for no apparent reason and nobody else was holding locks on the table. I dropped and recreated the primary key constraint and all was well. Of course, I don't know what the actual cause of the problem was, but my job was to get the developers back and working as fast as possible.

 You might consider seeing if this solves your problem. Received on Wed Jan 19 2000 - 10:23:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US