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

Thread: Quantity of Archive Log Files

  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Question Quantity of Archive Log Files

    I am currently in the middle of a data conversion project, and noticed something that surprised me a lot. I was inserting approx 1.1 million rows into a table, and after these inserts the table consumed approx 64 MB of data and 40 MB of index in the database. We have archivelog mode turned on, and the above operation generated approx 550 MB of archive logs !!

    Is this reasonable ? Are there any settings I can change to reduce this (whilst still remaining in archivelog mode).

    The operation is performed in a Package. Because the transaction was too big to do in a single INSERT INTO .. SELECT .., I use dbms_sql to fetch from the SELECT 100 rows at a time into a bunch of variables of type dbms_sql.xxx_table. I then insert them in one go, again using dbms_sql with the same bunch of variables. I then commit after every 10000 rows inserted.

    The database version is 9.2.0.1 (on Linux if that matters). The DB is configured to create log files of 50 MB.

    There are no updates, no triggers, and no other activity on the DB.

  2. #2
    Join Date
    Nov 2003
    Posts
    9
    How you are calculating the archive log size my guess is that you are counting the logswitch during the activity.

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    I'd imagine he is calculating the size of the archive logs by looking at the size of the generated files!

  4. #4
    Join Date
    Apr 2002
    Location
    France
    Posts
    118
    I guess You will be interseted in that link :
    http://asktom.oracle.com/pls/ask/f?p...7036069421885,
    If there is no solution, it is because there is no problem - Shadok -

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