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

Thread: Advance Query

  1. #1
    Join Date
    Dec 2001
    Posts
    203

    Question

    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

    Sumit
    sumit

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

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    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