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 10:36:59 +0200
Message-ID: <42997e4d$0$23523$626a14ce@news.free.fr>


>
> nologging is not a hint as far as I can recall...
>
> However, with the append hint, the undo generation should be small -
> have you got indexes on the table ? best to set these to unusable before
> adding lots of rows
>
> hth
> connor

Thanks Connor,
I thought NOLOGGING was a hint in 9i, not sure ( is there somewhere a list of all hints ? )
Yes there is a lot of indexes,
I would like to put them in unusable mode but I didn't see this parmeter in 9i only in 10g ???? Received on Sun May 29 2005 - 03:36:59 CDT

Original text of this message

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