CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_01.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1 MB?
-
Extent
-
Segement
-
Oracle block
-
Operating system block
A
Correct answer
Explanation
The UNIFORM SIZE 1M clause in a LOCALLY MANAGED tablespace specifies that each extent will be exactly 1 MB in size. This is the fundamental allocation unit in the tablespace. Segments are composed of multiple extents. Oracle block size is set at database level (typically 8K). OS block size is OS-dependent. The uniform allocation ensures all extents are the same size for performance and management.