Re: tuning an simple insert-statement

What is slow? How long does it take? Are you performing 100s of 1000s of these hard-coded things? Are there triggers firing? have you traced a session and determined what waits if any are occuring?

What expectations do you have for speed?

Pascal Ziegler wrote:
> hi,
>
> i have to insert several values with a simple insert-statement.
>
> e.g.
>
> INSERT INTO xy VALUES (1, 2, 3, 4); -- really simple ;-)
>
> (the table has just a primary-key index!!)
>
> i did this with oracle 9i and cache from intersystem! cache
> was about 5 times faster than oracle!! is this just
> the way it is or can i improve the performance of oracle!??
> and how?
>
> thanks
> - pascal
>

-- 
Ron Reidy
Oracle DBA