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 -> Re: Huge undotbs during insert

Re: Huge undotbs during insert

From: astalavista <spam_at_nowhere.com>
Date: Sun, 29 May 2005 09:56:52 +0200
Message-ID: <429974e7$0$1860$626a14ce@news.free.fr>

> Based on the fact that this is probably not the only thing happening
> on your system I wouldn't sweat it. 6GB in today's world is nothing.
>
> But you really should patch to 9.2.04 or 9.2.0.6 ASAP.

Thanks again Daniel, I will do that ... Do you know why there is no parallel processing when I do :

alter session enable parallel dml;
insert /*+ append nologging parallel (table1,4) */ into table2
select * from table1;

Something I miss ?

Thanks again Received on Sun May 29 2005 - 02:56:52 CDT

Original text of this message

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