DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: rollback segments

  1. #1
    Join Date
    Mar 2002
    Posts
    6

    Question

    is there a way to limit the number of transactions allowed in the rollback segment?

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Set Transactions_per_rollback_segment to a desired value in the init.ora file.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    does that apply for public rollback segments?

  4. #4
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    The transactions_per_rollback_segment parameter does not limit the number of transactions allowed in the rollback segment.

    It is used to determine how many PUBLIC rollback segments to bring online at startup. (transactions/transactions_per_rollback_segment) rounded up.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    TRANSACTIONS_PER_ROLLBACK_SEGMENT can not be used to limit the number of transactions per rollbeck sagment. And it doesn't matter if RBs are public or private.

    This parameter is there only to help the server to calculate how many rollback segments it has to open upon startup, based on the TRANSACTIONS parameter. But it doesn't impose any limit in the number of transactions each rollback can actually handle.

    AFAIK there is no way you can limit the number of transactions per rollback segment. Unless of course you have only one rollback segment online, whereas TRANSACTIONS parameter impose that limit.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    When many transactions are concurrently proceeding, more rollback information is generated at the same time. You can indicate the number of concurrent transactions you expect for the instance with the initialization parameter TRANSACTIONS, and the number of transactions you expect each rollback segment to have to handle with the initialization parameter TRANSACTIONS_PER_ROLLBACK_SEGMENT. Then, when an instance opens a database, it attempts to acquire at least TRANSACTIONS/ TRANSACTIONS_PER_ROLLBACK_SEGMENT rollback segments to handle the maximum amount of transactions. Therefore, after setting the parameters, create TRANSACTIONS/TRANSACTIONS_PER_ROLLBACK_ SEGMENT rollback segments.

    TRANSACTIONS_PER_ROLLBACK_SEGMENT specifies the number of concurrent transactions you expect each rollback segment to have to handle. The minimum number of rollback segments acquired at startup is TRANSACTIONS divided by the value for this parameter. For example, if TRANSACTIONS is 101 and this parameter is 10, then the minimum number of rollback segments acquired would be the ratio 101/10, rounded up to 11.


  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    But the question was "how to limit the number of transactions allowed in the rollback segment?", not how to specify the expected number of transactions per RB. As allready said, you can't use this parameter to limit the allowable transactions per RB.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by mgg
    is there a way to limit the number of transactions allowed in the rollback segment?
    Limit how? Like you want to specify (for example) a maximum of 17 transaction for RBS05? Not way to do that!

    But as you know there is the radical way of limitting them to 0 by taking the RBS offline :-)

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  9. #9
    Join Date
    Mar 2002
    Posts
    6

    Question

    so if I set the transactions =15 and the transactions_per_rollback_segment =1 and I have 15 rollback segments will this then force a transction into a separate rollback segment?

  10. #10
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Nope.

    The transactions_per_rollback_segment parameter is only read and used at instance startup to determine whether or not the system should bring more public rollback segments online.

    It doesn't limit usage. If t/tprs rounded up <= online public rb segs, nothing happens. End of story.

    It's a beautiful day in Nebraska!

    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

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