Re: Question on Rollback Segment

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 22 Jun 1999 13:38:42 GMT
Message-ID: <3772919d.95671518@newshost.us.oracle.com>

A copy of this was sent to manager43_at_my-deja.com (if that email address didn't require changing) On Tue, 22 Jun 1999 06:44:23 GMT, you wrote:

>Hi,
>
>Pls note that the quantity of segments depend from size
>of dababase block, for example, is DB = 2KB - 121, etc.
>

I think you mean the quanity of EXENTS in a segment. There is no limit on the number of segments. In 7.3, this went away with unlimited extents (well, 2billion is the real max now regardless of block size).

>Vladimir
>
>
>In article <MPG.11d881727cf7f620989692_at_news.singnet.com.sg>,
> wanni_at_mbox2.singnet.com.sg (Wanni) wrote:
>> Hi Readers,
>>
>> I have a puzzling question on how the rollback segment allocates its'
>> next extent.
>>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Jun 22 1999 - 08:38:42 CDT