DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Using NOLOGGING for large batch jobs

  1. #1
    Join Date
    Apr 2000


    We have a large batch job that transfers large amounts of data. One problem we have been having is the amount of redo being generated. I do not want to turn archiving off on our production database and recommend nologging. Our concerns are:

    1) Logging will continue to happen for indexes and tables that contain a primary key constraint. To correct this, the primary key constraint would have to be disabled and indexes would also need to have the NOLOGGING option turned on.

    2) If the primary key constraint is disabled, this raises many concerns with data integrity and may cause business rules to fail.

    3) Also, if the primary key constraint is disabled this also disables the index used for the primary key hurting performance even more.

    How do we address these concerns in order to use nologging?

  2. #2
    Join Date
    Jan 2001

    Nologging clause is fine for temprary tables where you are not concerned if some data is lost or integrity of data. If its a batch job and transferring large amount of data, I would leave it as it is and addres the space in archive directory by setting up monitoring jobs which will either backup and delete logs or move them to another directory.


  3. #3
    Join Date
    Apr 2000
    Thanks. That's what I was leaning towards, but since I saw several posts of Metalink from other people doing this, I thought I'd found out how they handled it.

  4. #4
    Join Date
    Apr 2001
    Brisbane, Queensland, Australia
    LOGGING will continue to occur regardless if the tables/tablespaces are in NOLOGGING mode. NOLOGGING doesn't affect normal data inserts, update, deletes etc.

    Also, even in NOARCHIVELOG mode, it doesn't stop LOGGING... all changes to the DB are logged, it's just that the LOGS arn't archived.

    Good luck!


    [Edited by grjohnson on 02-13-2002 at 08:23 PM]
    OCP 8i, 9i DBA
    Brisbane Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width