Re: Parallism with INSERTs and Deletes

I don't think it would speed things up to use more than 1 processor to insert a single row. The overhead of trying to do that would probably outweigh any advantage. Of course, if I have many users trying to insert rows at the same time it is possible and likely that each insert could run on a different processor.
insert into mytable (col1,col2,...) values(a,b,...); would be hard to parallize. where as
insert into mytable as select ... from otherTable ; is really many many of the first inserts and so it could reasonably be parrellized.

same where an update updates a small number of rows. A large number might be able to be done in parellell. I'll have to look at the docs for that. Does that help?
Jim

"David LeJeune" <dlejeune_at_yahoo.com> wrote in message news:f329f8a7.0110310720.785c84bb_at_posting.google.com...
> Hi -
>
> From everything I have read, ORACLE only supports parallism w/ INSERT
> into SELECT type statements. Normal INSERTs and UPDATES don't seem to
> be supported by the Parallel Query Option that comes w/ 8i Enterprise.
>
> Does anyone know what this means? Does this mean that only a single
> processor is used or does Oracle spread the INSERTs and UPDATES across
> multiple processors if you have a multi-processor server (i.e. like a
> SUN 4500).
>
> Thanks in Advance,
> Dave L.
Received on Wed Oct 31 2001 - 09:57:33 CST