Re: Rollback usage query
Date: 8 Apr 2004 02:23:29 -0700
Message-ID: <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 - 11:23:29 CEST