Re: How to disable redo log generation during star transformation

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 26 Aug 2011 07:32:55 -0700 (PDT)
Message-ID: <4e784f90-0303-435a-b68b-191042843985_at_s2g2000prm.googlegroups.com>



On Aug 26, 7:49 am, Pratap <pratap.deshm..._at_gmail.com> wrote:
> Hi,
>
> The database version is Oracle 11.1
>
> When star transformation enabled is set to true, I see redo log being
> generated. I believe this is because of the dimensions being loaded
> into temp tables (SYS_TEMP_*).
>
> Is it possible to disable this redo log generation without using
> temp_disable?
>
> These temp tables are created in the SYS schema. Can we alter system
> tablespace to nologging?
>
> Regards,
> Pratap

Altering a tablespace to nologging does not effect the logging on existing object nor should you even consider using nologging on the system tablespace. The nologging setting also only applies to certain type of DML activity such as direct loads anyway.

What statistics (query) are you looking that identifies the high redo log generation as being from the session in question performing the start transformation?

HTH -- Mark D Powell -- Received on Fri Aug 26 2011 - 09:32:55 CDT

Original text of this message