Re: How does ORACLE manages the rollback segments ??

From: Reinhard Kuhn <kuhn_at_cas-ps.com>
Date: 1996/01/31
Message-ID: <4enjvj$628_at_fred.cas-ps.com>#1/1


In article <4elhnv$hnf_at_news2.aimnet.com>, bfntd_at_aimnet.com says...
>
>Pierre ROUSSIN (roussin_at_micronet.fr) wrote:
>: We want to know how the rollback segments are dispatched to
>: the user processes. And why if it's the case; two users get
>: to be on the same RBS.
>I believe you can specify the order in the parameter file:
>Transactions will then be assigned in order to r01, r03, r02, r04
>then back around to r01. Multiple transactions can be assigned to
>HTH,
>Tony Damon

Rollback segments are assigned in a round-robin fashion independent of their order in the parameterfile.

Oracle always takes the rollback segment with

  1. the least number of active transactions
  2. if more than 1 segment satisfy a), the one after the last used segment

hope this helps

-- 
    _/_/_/   _/_/_/ _/    _/  // Reinhard Kuhn             /  It can be      
   _/    _/ _/     _/  _/    //         (kuhn_at_cas-ps.com) /  done quickly,   
  _/_/_/   _/_/_/ _/_/      // CAS GmbH                  /  cheaply or well  
 _/  _/   _/     _/  _/    // Lemberger Strasse 14      /   - pick any two!  
_/   _/  _/_/_/ _/    _/  // 66955 Pirmasens, Germany  /   
                                   
Received on Wed Jan 31 1996 - 00:00:00 CET

Original text of this message