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
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
- the least number of active transactions
- 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