Re: Parallism with INSERTs and Deletes

I believe so. I understand about the inserts. They simply are done individually. Just wanted to make sure that as a whole (a bunch of them) that the Oracle server software would spread them across processors. Would make sense that it would, but I wasn't sure.

For UPDATEs I guess it does depend on how intensive they are. But if they do update alot of rows, I would think they could be split across processors by the PQO. maybe not. Any guidance you could give would be great.

Any ideas what's the best way to monitor processor usage with regards to Oracle statements?

Thanks Again,
Dave L.

"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:<NbVD7.4979$Fm5.2665153_at_news1.sttln1.wa.home.com>...
> 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 - 16:26:16 CST