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

Re: Slow inserts with Oracle 10g

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 23 Nov 2005 13:25:10 -0800
Message-ID: <1132781112.8655@yasure>


Clemenza wrote:
> 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!

Wholly insufficient information from which to formulate a response. Where are the metrics?
Where is the StatsPack?
You seemingly don't have an error ... you have a lack of information.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Nov 23 2005 - 15:25:10 CST

Original text of this message

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