Focus On Oracle

Installing, Backup & Recovery, Performance Tuning,
Troubleshooting, Upgrading, Patching

Oracle Engineered System


当前位置: 首页 » 技术文章 » Oracle 12c+

Exadata with database 12.2

在Create database时,我们可以指定默认表空间类型

SET DEFAULT BIGFILE TABLESPACE/SET DEFAULT SMALLFILE TABLESPACE
CREATE DATABASE mynewdb
     USER SYS IDENTIFIED BY sys_password
     USER SYSTEM IDENTIFIED BY system_password
     SET DEFAULT BIGFILE TABLESPACE
     UNDO TABLESPACE undotbs
     DEFAULT TEMPORARY TABLESPACE tempts1;

创建后可以手动修改默认表空间类型

ALTER DATABASE SET DEFAULT SMALLFILE TABLESPACE; 

在Exadata上,12.2的数据库默认的表空间类型为BIGFILE,这说明Oracle对Bigfile在Exadata中的认可。BIGFILE只有一个数据文件,在8k情况下,最大大小为32T(SMALL数据文件每个最大32G,有1022个数据文件),这个是有oracle的rdba的特点决定的。

8k 32T

16K 64T

32K 128T

SQL> create tablespace test datafile '+DATA' size 16G;

Tablespace created.

Elapsed: 00:00:00.69
SQL> alter tablespace test add datafile '+DATA' size 16G;
alter tablespace test add datafile '+DATA' size 16G
*
ERROR at line 1:
ORA-32771: cannot add file to bigfile tablespace

Elapsed: 00:00:00.00
SQL>
SQL> create tablespace test03 datafile '+DATA' size 33T;
create tablespace test03 datafile '+DATA' size 33T
*
ERROR at line 1:
ORA-00740: datafile size of (4429185024) blocks exceeds maximum file size

Elapsed: 00:00:00.05
SQL>


关键词:12c exadata 

相关文章

How to generate AWR on PDB and ADG(12.2 afterwards)
Oracle ZDLRA (Zero Data Lost Recovery Appliance) FAQ
Oracle ZDLRA (Zero Data Lost Recovery Appliance) Features
Oracle Database 18c On Exadata
Migrate Oracle Database on AIX to Exadata
在12c上使用wm_concat
ExaWatcher Charts
qperf & iperf
How to config IB network listener
Recreate quorum disk on X6-2
How to install/deploy Exadata
Exadata的特性

联系我们

韩朝阳



    Phone:186-9589-1286

    E-mail:ohsdba@qq.com

    微  信: ohsdba


电话(186-9589-1286)

QQ(375349564)

微信(ohsdba)


常用链接

Oracle
eDelivery
My Oracle Support

Exadata 12.1 Document

Exadata 12.2 Document

Oracle 11gR2 Document

Oracle 12cR1 Document

Oracle 12cR2 Document

GoldenGate 12c

Oracle Fusion Middleware

Mysql Document

PostgreSQL

Python

github

sourceforge



Top
Cell186-9589-1286
QQ 375349564
E-mail ohsdba@qq.com