SQL>  select file_name,autoextensible,increment_by from dba_data_files order by 3 ;

FILE_NAME                                     AUT INCREMENT_BY
--------------------------------------------- --- ------------
/u01/app/oracle/oradata/ORCL/bcscm/test.dbf   YES          128


-- INCREMENT_BY , 单位是数据块,即每次增长128个数据块, 128个数据块  ×  8k / 块 = 1M


  • No labels
Write a comment…