Question on Direct-Insert Nologging
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Question on Direct-Insert Nologging

  1. #1
    Join Date
    Sep 2001
    Posts
    261

    Question

    Hi! i got a question again from the Oracle Assessment Test,

    You inserted data into the EMP table using the direct-load insert with the NOLOGGING option.
    With information was recorded in the redo logs?

    A. No redo log entries were recorded
    B. Only certain data dictionary changes were recorded

    My answer is A but the Assessment Test's answer is B.

    Hope you guys can clear things up for me again. Thank you very much!

    The Maverick




  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    The answer is B, because Oracle has to mark the news extents invalid and record the changes in the dictionary. This is a minimal log activity.


  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    B

    there is never ever transactions without redo, there is no redo regarding your transaction but there is regading the internal oracle transactions such as dictionary changes, for examples extents as julian pointed, or DDL changes (create index for example) or if audit trail is enabled then the dml on aud$ table has to be recorded somewhere

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