Re: Slow inserts with Oracle 10g

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Wed, 23 Nov 2005 23:06:59 +0100
Message-ID: <4384e804$0$20238$ba620e4c@news.skynet.be>

"Clemenza" <clemenza_at_gmx.de> wrote in message news:dm2cm0$ipp$1_at_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!

Did you gather table and index statistics ? Are you using the same (or comparable) init.ora (spfile)parameters ? Received on Wed Nov 23 2005 - 16:06:59 CST