| Oracle® Database Administrator's Reference 11g Release 1 (11.1) for Linux and UNIX-Based Operating Systems Part Number B32009-01 |
|
|
View PDF |
| Oracle® Database Administrator's Reference 11g Release 1 (11.1) for Linux and UNIX-Based Operating Systems Part Number B32009-01 |
|
|
View PDF |
This appendix describes database limits.
Table G-1 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 G-1 CREATE CONTROLFILE and CREATE DATABASE Parameters
| Parameter | Default | Maximum Value |
|---|---|---|
|
16 |
255 |
|
|
2 |
5 |
|
|
100 |
65534 |
|
|
30 |
65534 |
|
|
1 |
63 |
Table G-2 lists the Oracle Database file size limits in bytes.
Table G-2 File Size Limits
| File Type | Platform | |
|---|---|---|
|
Data files |
Any |
4,194,303 multiplied by the value of the |
|
Import/Export files and SQL*Loader files |
AIX, HP-UX, Linux, and Solaris: 32-bit with 32-bit files |
2,147,483,647 bytes |
|
AIX, HP-UX, Linux, Mac OS X, and Solaris: 64-bit files |
Unlimited |
|
|
Control files |
HP-UX, Linux, Mac OS X, and Solaris |
20000 database blocks |
|
AIX |
10000 database blocks |
