联系:手机/微信(+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.