Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Unanswered: optimizing logsegment filling

    I am using single trasanction to insert some 1000's of rows in a single transaction and it is need as requirement. Since the data to be inserted in the tables is varies logsegement size cann't be fixed. This porgram right now running in production, but it is filling up the logsegement when more number of rows are inserted.
    My requirement is I need this insertion should be in a single trancation and logsegement should not be filled up. Can some one please tell me how to do this.
    Thanks and Regards,
    Last edited by Sabbi; 06-02-04 at 13:45. Reason: spelling mistake

  2. #2
    Join Date
    Nov 2002
    Based on your requirement, keep on extending the log until you come to a stage where it is no more extension is required. Other option is to do batch inserts in which case you can control the log filling up.

Posting Permissions

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