Oracle-L: Re: Re[2]: undo tablespace

From: Stephen Evans <evans036_at_mc.duke.edu>
Date: Wed, 29 Jan 2003 07:59:09 -0800
Message-ID: <F001.0053D571.20030129075909@fatcity.com>

breno,

i believe the 'no logging' option only applies to data that is direct loaded into your tables

therefore, you may be able to bypass logging if you used sqlldr or 'create table as select'

good luck,

steve

"Breno A. K. Magnago" <breno_at_mercantilsoares.com.br> Sent by: root_at_fatcity.com
01/29/2003 09:09 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re[2]: undo tablespace

Mike,

I asked it because I have a problem.
Any insert data in UNDO tablespace generate insert in REDO Files. Is is correct ?

When I execute a high procedure, many inserts in UNDO tablespace ocurres, so many inserts in REDO´s are genereate. I want to avoid this REDO´s generation.
My tables and indexes are in NOLOGGING, but I high value of REDO are generate (100 MB each 20 minutes). It is desnecessary.

Oracle 9i / NT

Breno A. K. Magnago                            mailto:breno_at_mercantilsoares.com.br

Mercantil de Alimentos Soares

Wednesday, January 29, 2003, 10:29:15 AM, you wrote:

HMNI> Breno,
HMNI> There's no way to do this because it's the central pillar of Oracle's read
HMNI> consistency mechanism.
HMNI> It's possible to minimise or suppress redo but undo is out of your control.

HMNI> regards,
HMNI> Mike Hately

HMNI> -----Original Message-----
HMNI> Sent: 29 January 2003 11:39
HMNI> To: Multiple recipients of list ORACLE-L


HMNI> I have a high procedure (many INSERT's and UPDATE´s).
HMNI> This procedure generate insert's in UNDO TableSpace for rollback.

HMNI> I want to know if exists any way for don´t generate insert´s in UNDO HMNI> Tablespace.

HMNI> Oracle 9i / NT

HMNI> Thanks.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Breno A. K. Magnago
INET: breno_at_mercantilsoares.com.br

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Stephen Evans
INET: evans036_at_mc.duke.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------