D Database Limits
This appendix describes database limits.
D.1 Database Limits
The following table lists the default and maximum values for parameters in a CREATE DATABASE or CREATE CONTROLFILE statement.
Note:
Interdependencies between these parameters may affect permissible values.
Table D-1 CREATE CONTROLFILE and CREATE DATABASE Parameters
| Parameter | Default | Maximum Value |
|---|---|---|
|
16 |
4220 |
|
|
2 |
5 |
|
|
100 |
65534 |
|
|
30 |
65534 |
|
|
1 |
1055 |
The following table lists the Oracle Database file size limits in bytes.
Table D-2 File Size Limits
| File Type | Platform | File size limit |
|---|---|---|
|
Data files |
Any |
4,194,303 multiplied by the value of the |
|
Import/Export files and SQL*Loader files |
Oracle Solaris, Linux, IBM AIX on POWER Systems (64-Bit), and HP-UX: 32-bit files |
2,147,483,647 bytes |
|
Import/Export files and SQL*Loader files |
Oracle Solaris, Linux, IBM AIX on POWER Systems (64-Bit), and HP-UX: 64-bit files |
Unlimited Note: File size is limited by limits allowed by the operating system on different file systems. |
|
Control files |
Oracle Solaris, Linux, IBM AIX on POWER Systems (64-Bit), and HP-UX |
25000 control file blocks with a block size of 4096 bytes. |