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

Thread: Fast Commit

  1. #1
    Join Date
    Jul 2001
    Posts
    52


    Dear Friends

    as you know if i am saving 1 record or 1000000 rows it
    will take same time. can any body guide me how iternally
    it will work.

    Rakesh Sanghvi

  2. #2
    I can tell you that to insert one row of data, not only must Oracle create Rollback information it must also run about 4 other queries updating the data dictionary, update any indexes, store all this information in the rollback segment as well. If a rollback segment needs more extents these must be allocated and again the data dictioanry must be updated.

    In short a simple insert is far from simple.

    To insert 100000 rows is the same thing. You just need a bigger rollback segment.


    There is probably more to it. I read a book once that dedicated a chapter to what happens when you insert a row. You'd be surprised.

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