联系：手机/微信(+86 17813235971) QQ(107644445)
标题：Oracle 23ai 变化之—-默认数据文件变为bigfile
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
oracle把23c变为23ai，引入了很多新特性,今天下载了free版本的虚拟机登录进去第一感觉就是system,sysaux,undo等文件以前版本默认的smallfile变为了bigfile
SQL> select BANNER_FULL from v$version;
BANNER_FULL
----------------------------------------------------------------------------------
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.4.0.24.05
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 FREEPDB1 READ WRITE NO
SQL> select con_id,ts#,name,bigfile from v$tablespace order by 1,2;
CON_ID TS# NAME BIG
---------- ---------- ------------------------------ ---
1 0 SYSTEM YES
1 1 SYSAUX YES
1 3 TEMP NO
1 4 USERS YES
1 5 UNDOTBS2 YES
2 0 SYSTEM YES
2 1 SYSAUX YES
2 2 UNDOTBS1 YES
2 3 TEMP NO
3 0 SYSTEM YES
3 1 SYSAUX YES
3 2 UNDOTBS1 YES
3 3 TEMP NO
3 6 USERS NO
14 rows selected.
SQL> select con_id,file#,ts#,rfile#,name from v$datafile;
CON_ID FILE# TS# RFILE# NAME
---------- ---------- ---------- ---------- ------------------------------------------------------
1 1 0 1024 /opt/oracle/oradata/FREE/system01.dbf
2 2 0 1024 /opt/oracle/oradata/FREE/pdbseed/system01.dbf
1 3 1 1024 /opt/oracle/oradata/FREE/sysaux01.dbf
2 4 1 1024 /opt/oracle/oradata/FREE/pdbseed/sysaux01.dbf
1 7 4 1024 /opt/oracle/oradata/FREE/users01.dbf
2 9 2 1024 /opt/oracle/oradata/FREE/pdbseed/undotbs01.dbf
3 12 0 1024 /opt/oracle/oradata/FREE/FREEPDB1/system01.dbf
3 13 1 1024 /opt/oracle/oradata/FREE/FREEPDB1/sysaux01.dbf
3 14 2 1024 /opt/oracle/oradata/FREE/FREEPDB1/undotbs01.dbf
3 15 6 15 /opt/oracle/oradata/FREE/FREEPDB1/users01.dbf
1 16 5 1024 /opt/oracle/oradata/FREE/undotbs2.dbf
11 rows selected.