Re: Rollback usage query

Thank Matt.

Regards,
Alice

"Matt" <mccmx_at_hotmail.com> wrote in message news:cfee5bcf.0404080123.64767013_at_posting.google.com...
> No. A transaction will only use as much space as it requires.
>
> The rollback segment tablespace is just like any other tablespace (as
> far as storage is concerned). Therefore it will allocate storage in
> multiples of database blocks (db_block_size).
>
> A rollback segment that has 20 extents of 5Mb each has 100Mb available
> for use by any number of transactions concurrently.
>
> Matt
>
>
>
> "Alice" <alice_at_reply-to-group.com> wrote in message
 news:<40742a46_1_at_news.tm.net.my>...
> > Hi all,
> >
> > Given a rollback segment with storage as follows :
> > Initial Extent 5 MB
> > Next Extent 5 MB
> > Min Extents 20
> >
> > Does this mean that every time a transaction uses this rollback segment
 it
> > allocates 100 MB ?
> > Does this mean that if there are two transactions using this rollback
> > segment, 200 MB is required ?
> >
> > Thanks,
> > Alice
Received on Thu Apr 08 2004 - 16:19:35 CEST