RE: what did I miss? -- nologging generating redo

From: Balakrishnan, Ashok - VSCM <Balakrishnan.Ashok_at_vectorscm.com>
Date: Thu, 20 Mar 2003 16:16:19 -0800
Message-Id: <24726.322598@fatcity.com>

Since you mentioned Standby database and depending on the version of Oracle you have (9202 here), have you disable NOLOGGING at the database level by using "ALTER DATABASE FORCE LOGGING" (If I remember the syntax).

We have done exactly that to prevent any NOLOGGING operations since there's a standby database configured on a remote site and we wouldn't want any developers to use nologging to load a bunch of data that won't get sent to the standby site.

-----Original Message-----
From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com] Sent: Thursday, March 20, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L Subject: Re: what did I miss? -- nologging generating redo

My off the cuff response is "did you have direct=yes" set in the parm file or on the command line?

IIRC this is basically the same as using the '/*+ APPEND *' hint in an INSERT statement.

Jared

"Steve McClure" <smcclure_at_usscript.com>
Sent by: root_at_fatcity.com
03/20/2003 03:13 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        what did I miss? -- nologging generating redo

Allright I have a developer that is loading a few gig of historical data, that will only be used for a very short period of time. I wanted to avoid dealing with all the redo this is going to create. I created a new tablespace using the nologging option. The table and it's indexes were created with the nologging option. Yet as the developer started his load, using sqlloader, I got swamped with redo logs. The only problem this presents is that we have a standby db that is located offsite, and at times
when we have heavy redo activity the archiver processes swamp our bandwidth.
So no harm was really done, except I have to manually transfer all those archived logs. I am just wondering what I missed.

Thanks,
Steve

--

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

Author: Steve McClure
INET: smcclure_at_usscript.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).

--

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

Author:
INET: Jared.Still_at_radisys.com

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