RE: Nologging clause

Greg,

Thanks for the reference. I just looked at the asktom article and he has 
created this table there -

Table Mode    Insert Mode     ArchiveLog mode      result
-----------   -------------   -----------------    ----------
LOGGING       APPEND          ARCHIVE LOG          redo generated
NOLOGGING     APPEND          ARCHIVE LOG          no redo
LOGGING       no append       ""                   redo generated
NOLOGGING     no append       ""                   redo generated
LOGGING       APPEND          noarchive log mode   no redo
NOLOGGING     APPEND          noarchive log mode   no redo
LOGGING       no append       noarchive log mode   redo generated
NOLOGGING     no append       noarchive log mode   redo generated

It appears that he is saying that if a table is set to nologging and my insert 
mode is append then even if archive logging is on no redo will be generated. 
I'm still not sure I am understanding this correctly but I take that to mean

SQL> insert /*+ APPEND */ into <table>;

Then no redo will be generated. Is that a correct understanding? 

Thanks.


Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208

-----Original Message-----
From: Greg Rahn [mailto:greg@xxxxxxxxxxxxxxxxxx] 
Sent: Tuesday, March 31, 2009 4:32 PM
To: William Wagman
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Nologging clause

Conventional inserts into a nologging tablespace/object still generate
redo in archive log mode. Only direct path operations will be
nologging.  The other option is to switch to noarchive log mode.

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5280714813869


On Tue, Mar 31, 2009 at 4:07 PM, William Wagman <wjwagman@xxxxxxxxxxx> wrote:
> Greetings,
>
> I am running oracle 10.2.0.3 SE. We are in the process of implementing CAS 
> (Central Authentication Service). The request has been made to use an 
> existing production database to house the repository for the tickets. The 
> database in question is one which will be phased out so usage is declining 
> and will ultimately be used only for the CAS repository. Currently the 
> database is in archivelog mode. There is no need to be able to do a point in 
> time recovery of the CAS repository so I would like to turn off logging of 
> those transactions to keep the archive logs from growing and grabbing all 
> available space (there is enough space to hold the existing application, the 
> CAS application but probably not enough to hold all the redo which would be 
> generated by the CAS tickets and the existing application). I agree, it 
> sounds strange. The tables holding the CAS tickets are in a separate 
> tablespace. If I alter that tablespace and set nologging will that stop redo 
> being generated against transactions in that tablespace? As I understand the 
> documentation setting nologging will prevent redo generation for transactions 
> in that tablespace. I don't have a setup in which to test this. I hope I have 
> stated my question clearly.


-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l


Other related posts: