Re: How does ORACLE manages the rollback segments ??

From: Leng Kaing <leng_at_cougar.vut.edu.au>
Date: 1996/01/30
Message-ID: <4el13t$geb_at_cougar.vut.edu.au>#1/1

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.

There's a whole chapter in the DBA Guide devoted to this topic. Read the manuals. I think it will answer you question. Just a rough outline, you can set a transaction to use a particular rbs. But you can't stop other transactions from using the same rbs. Oracle does the allocation. There's also an init.ora parameter that specifies the max number of transactions per rollback segments.

HTH,
Leng.

--
Leng Kaing
DBA - Directory Technology P/L
Email: lkaing_at_ventnds1.telecom.com.au
Ph: +61-3-9892-9081  Fax: +61-3-9892-9344

Received on Tue Jan 30 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Scott Urman: "Re: How Do You Insert Long Raw Data?"
Previous message: Clive Bostock: "Re: How does ORACLE manages the rollback segments ??"
In reply to: Pierre ROUSSIN: "How does ORACLE manages the rollback segments ??"
Next in thread: Scott Urman: "Re: How Do You Insert Long Raw Data?"
Reply: Reinhard Kuhn: "Re: How does ORACLE manages the rollback segments ??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message