question

OraLearner avatar image
OraLearner asked

What are the min.extents allocated to a rollback extent ?

How many minimum extens allocated to a rollback extent ? Thank you for the answer in advance.

oraclerollbackextent
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Christian13467 avatar image
Christian13467 answered

Rollback segment should be used in locally managed tablespaces. There is no number of min extents. The minimum number is 1 and is created with the initial extent size given at create rollback segment statement. But the number of extents is growing if storage is needed.

http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_6013.htm#sthref6997

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.