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

Thread: Current Rollback Segment?

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Hi,

    How do I see , which is the current rollback segment my session is using?

    If I have set the transaction to use one rollback segment, till when is it valid ?
    When I issue commit/rollback command will the rollback segments go back to the default rollback segment
    Badrinath



  2. #2
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    You can check from v$tansaction which transaction is using what RBS.
    The RBS that is set thru SET TRANSACTION is used till you issue a commit/rollback.
    There is nothing like default RBS.

  3. #3
    Join Date
    Jan 2001
    Posts
    642
    Thanks for that info.

    For batch deletes:

    I set the rollbacksegment to a large one ("Large_RBS").

    I run a procedure to delete the records for a table, and still to be on a safer end, I commit at the end of 1000 records.(inside the procedure)

    Does this stop using the "Large_RBS".

    Badrinath

    While doing this

  4. #4
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    Yes.

  5. #5
    Join Date
    Jan 2001
    Posts
    642
    I'm, trying to use v$transaction, It doesn't show which RBS is being used

    Badrinath

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