hi,
I've got the following version of Oracle.
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
Thanks for taking the time to read my question. I understand that database objects like tables and indexes are represented as segments and segments are comprised of extents. Extents are comprised of blocks. But, why does Oracle provide DBAs with the ability to specify sizes of extents? For example, if a table is created and rows are added to the table over time, why not just have 1 extent for the table which would extend automatically as more and more data is added to the table? What would be the purpose of or reason for spreading the data across different extents?