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

Thread: Advance Query

  1. #1
    Join Date
    Dec 2001


    Hello All,

    There is a tablespace RBSTBLSPACE. The size of the tablespace is 100M. Autoextend is off.

    I have associated 2 rollback segment with that. RB1 and RB2.
    I also have set an Optimal value.

    I have executed a long statement. Suppose that has been associated with RB1.

    My query is,

    1) if the statement occupies all the blocks till optimal size ... and the statement yet to complete , what will happen? RB1 rollback segment still grow untill the full tablespace size has been occupied?

    2) If it grows and occupies the total tablespace size , but the statement yet to finish, then what will happen? Will the whole statement rollback or it will again start occuping the first block in the tablespace?

    An early response will be very much appreciated.

    Thanks and regards


  2. #2
    Join Date
    Jun 2000
    Madrid, Spain
    1. rbs will eats up the whole tablespace
    2. rolls back the transaction

  3. #3
    Join Date
    Nov 2000
    Originally posted by sumit
    I have executed a long statement. Suppose that has been associated with RB1.
    1. depends on what you mean by this. If it is an UPDATE, DELETE, or INSERT statement, the previous post was correct. If it is a SELECT statement, the RBS will stay the same size until oracle can no longer get a consistent view of the data. Once that happens, you will get an ORA-1555.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.