SQL> create tablespace test2 2 datafile 'F:\oracle92\oradata\sun\test2' size 10M 3 autoextend on next 20M maxsize 100M; 表空间已创建。 SQL> select FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE,MAXBYTES,INCREMENT_BY from dba_data_files where tablespace_name='TEST2'; FILE_NAME TABLESPACE_NAME AUTOEX MAXBYTES INCREMENT_BY ------------------------------ --------------- ------ ---------- ------------ F:\ORACLE92\ORADATA\SUN\TEST2 TEST2 YES 104857600 2560 SQL> show parameter db_block_size NAME TYPE VALUE ------------------------------------ ---------------------- ------------------------------ db_block_size integer 8192 SQL> select 2560*8192/1024/1024 from dual; 2560*8192/1024/1024 ------------------- 20
oracle 表扩展大小,查询ORACLE表空间或者数据文件每次扩展大小
最新推荐文章于 2022-04-06 10:15:48 发布