|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
Tablespace extent management
The allocation of extents within the tablespace is managed through the dictionary tables uet$ and fet$.
If the system tablespace is not dictionary managed, it has the following implications:
The allocation of extents within the tablespace is managed through bits (which are stored within the tablespace itself). Each bit corresponds to an extent.
Oracle will choose extent sizes.
All extent sizes within such a tablespace are equal in size.