Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Parallism with INSERTs and Deletes

Parallism with INSERTs and Deletes

From: David LeJeune <dlejeune_at_yahoo.com>
Date: 31 Oct 2001 07:20:45 -0800
Message-ID: <f329f8a7.0110310720.785c84bb@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:20:45 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US