Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Slow inserts with Oracle 10g
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
![]() |
![]() |