RE: Re[4]: undo tablespace

I think it might be a typo, or I've not had enuf coffee yet today, but the nologging on b.table2 wouldn't impact the redo logging; nologging on a.table1 would, tho...

> -----Original Message-----
> From: Breno A. K. Magnago [mailto:breno_at_mercantilsoares.com.br]
> Sent: Wednesday, January 29, 2003 10:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re[4]: undo tablespace
>
>
> Mike,
>
> What type of operation are you performing on your table?
>
> INSERT INTO A.TABLE1(COL1,COL2)
> SELECT COL1,COL2
> FROM B.TABLE2_at_DB_LINK;
>
> I think that command support the NOLOGGING.Is is correct ?
> The table B.TABLE2 and all indexes are in NOLOGGING Option.
>
> --
> Breno A. K. Magnago
> mailto:breno_at_mercantilsoares.com.br
>
> Wednesday, January 29, 2003, 2:04:39 PM, you wrote:
>
> HMNI> You're correct in saying that your undo blocks are protected by
> HMNI> your redo files. What type of operation are you
> performing on your
> HMNI> table? I ask because only a small subset of commands
> support the
> HMNI> NOLOGGING feature; the remainder will generate redo as usual.
>
> HMNI> If you're not using a syntax that supports NOLOGGING maybe you
> HMNI> could adapt your job to adopt one. Alternatively you
> may find that
> HMNI> you just need to optimise your redo log placement in order to
> HMNI> handle the load.
>
> HMNI> Regards,
> HMNI> Mike Hately
>
>
> HMNI> -----Original Message-----
> HMNI> Sent: 29 January 2003 14:10
> HMNI> To: Multiple recipients of list ORACLE-L
>
>
> HMNI> Mike,
>
> HMNI> I asked it because I have a problem.
> HMNI> Any insert data in UNDO tablespace generate insert in
> REDO Files.
> HMNI> Is is correct ?
>
> HMNI> When I execute a high procedure, many inserts in UNDO
> tablespace
> HMNI> ocurres, so many inserts in REDO´s are genereate. I
> want to avoid
> HMNI> this REDO´s generation. My tables and indexes are in NOLOGGING,
> HMNI> but I high value of REDO are generate (100 MB each 20
> minutes). It
> HMNI> is desnecessary.
>
> HMNI> Oracle 9i / NT
>
>
> --
> 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: Jeremy Pulcifer
  INET: Jeremy.Pulcifer_at_kadiri.com

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).