470,631 Members | 1,640 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,631 developers. It's quick & easy.

Rollback usage query

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
Jul 19 '05 #1
2 3563
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" <al***@reply-to-group.com> wrote in message news:<40********@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

Jul 19 '05 #2
Thank Matt.

Regards,
Alice

"Matt" <mc***@hotmail.com> wrote in message
news:cf**************************@posting.google.c om...
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" <al***@reply-to-group.com> wrote in message

news:<40********@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

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by jacob.miles | last post: by
1 post views Thread by cheesey_toastie | last post: by
2 posts views Thread by Ian Boyd | last post: by
2 posts views Thread by Alice | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.