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 -> Slow inserts with Oracle 10g

Slow inserts with Oracle 10g

From: Clemenza <clemenza_at_gmx.de>
Date: Wed, 23 Nov 2005 19:33:26 +0100
Message-ID: <dm2cm0$ipp$1@namru.matavnet.hu> 





Hello,



we use Oracle 10g on Solaris 10. Before we used Oracle 8i with Solaris 
8. We made a test where we insatelled the OS than Oracle and right after 
inserted ~35.000 records in empty tables.
At the moment we have a problem that the insert statements - on Oracle 
10 - cpu time takes 50-100% more than before and the elapsed time 
sometimes 200% more regarding Oracle statistics.




Do you have any idea how can we procced with such an error?



Thanks!
Received on Wed Nov 23 2005 - 12:33:26 CST












Original text of this message













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