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

Thread: NoLog

  1. #1
    Join Date
    Apr 2002
    Posts
    55
    Hi,

    I have a table with 1 million records.If I issue a delete on that table :

    Delete table sales_master;

    It takes 2.52 minutes , If I issue without logging

    Delete table sales_master nolog;

    It takes 2.33 minutes and if I truncate it

    Truncate table sales_master ;

    It takes .01 minute...

    Can anyone expain that why nolog takes so much time and after I rollback the data is rolled back without log also.

    Thanks.

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    just because it hasn't recorded the delete in the redo logs, it still has to record the before image in the RBS.
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    nologging only works on INSERT

  4. #4
    Join Date
    Apr 2002
    Posts
    55

    So whats the use of using nolog.

  5. #5
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Hi

    When u have a large amount of rows to be loaded then nolog will speed up the process at the cost of norecoverability as no redo information is generated / stored in the redo logs.

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