本文主要是介绍oracle tablespace next参数的理解，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
想要整理一下表空间等相关知识：
Use this clause to determine whether the tablespace is a bigfile or smallfile tablespace. This clause overrides any default tablespace type setting for the database.
-
A bigfile tablespace contains only one data file or temp file, which can contain up to approximately 4 billion (232) blocks. The maximum size of the single data file or temp file is 128 terabytes (TB) for a tablespace with 32K blocks and 32TB for a tablespace with 8K blocks.
-
说白了就是一个文件对于32K数据块最大文件可以扩展到128TB，8K数据块最大可以扩展到32TB。
-
A smallfile tablespace is a traditional Oracle tablespace, which can contain 1022 data files or temp files, each of which can contain up to approximately 4 million (222) blocks.
-
小文件表空间就是一个表空间可以加多个数据文件，最多可以加1022个。表空间最多可以存4 million (222) blocks，也就是32K数据块最大文件可以扩展到128TB，8K数据块最大可以扩展到32TB。
If you omit this clause, then Oracle Database uses the current default tablespace type of permanent or temporary tablespace set for the database. If you specify BIGFILE for a permanent tablespace, then the database by default creates a locally managed tablespace with automatic segment-space management.
如果省略此子句，则Oracle数据库使用数据库的当前默认的永久表空间类型或临时表空间集。如果为永久表空间指定BIGFILE，则默认情况下数据库将创建具有自动段空间管理的本地管理表空间。
This clause lets you specify default storage parameters for all objects created in the tablespace and default compression of data for all tables created in the tablespace. This clause is not valid for a temporary tablespace or a locally managed tablespace.
For a dictionary-managed tablespace, you can specify the following storage parameters with this clause: COMPRESS, INITIAL, NEXT, MINEXTENTS, MAXEXTENTS, and PCTINCREASE.
这个子句让你指定默认存储参数为表空间中的所有创建的对象，表空间中所有创建的表是默认数据压缩。这个子句对临时表空间或者本地管理的表空间是没用的。
对于数据字典管理的表空间，你能指定以下存储参数语句： COMPRESS, INITIAL, NEXT, MINEXTENTS, MAXEXTENTS, and PCTINCREASE.
解释几个时常关注的参数：
Specify in bytes the size of the next extent to be allocated to the object. Refer to size_clause for information on that clause.
In locally managed tablespaces, any user-supplied value for NEXT is ignored and the size of NEXT is determined by Oracle if the tablespace is set for autoallocate extent management. In UNIFORM tablespaces, the size of NEXT is the uniform extent size specified at tablespace creation time.
In dictionary-managed tablespaces, the default value is the size of 5 data blocks. The minimum value is the size of 1 data block. The maximum value depends on your operating system. Oracle rounds values up to the next multiple of the data block size for values less than 5 data blocks. For values greater than 5 data blocks, Oracle rounds up to a value that minimizes fragmentation.
在本地管理表空间中，表空间设置为自动分配extent管理，用户提供的任何NEXT值都是被忽略的，而NEXT大小则由Oracle决定。在统一表空间中，NEXT的大小是表空间创建时指定的统一范围大小。
在数据字典管理的表空间，NEXT默认值是5个数据块。最小值是1个数据块。最大值依赖操作系统。NEXT小于5个数据块的值，oracle循环增长数据块大小的倍数。对于大于5个数据块的值，Oracle循环到一个最小化碎片的值。
这篇关于oracle tablespace next参数的理解的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
