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-----
Sent: Thursday, March 20, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L
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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/20/2003 03:13 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Balakrishnan, Ashok - VSCM
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
