| Oracle® Database Administrator's Reference 10g Release 2 (10.2) for UNIX-Based Operating Systems Part Number B15658-05 |
|
|
View PDF |
| Oracle® Database Administrator's Reference 10g Release 2 (10.2) for UNIX-Based Operating Systems Part Number B15658-05 |
|
|
View PDF |
This appendix describes database limits.
Table H-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 H-1 CREATE CONTROLFILE and CREATE DATABASE Parameters
| Parameter | Default | Maximum Value |
|---|---|---|
|
16 |
255 |
|
|
2 |
5 |
|
|
100 |
65534 |
|
|
30 |
65534 |
|
|
1 |
63 |
Table H-2 lists the Oracle Database file size limits in bytes.
Table H-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 |
Tru64 UNIX |
16 TB |
|
|
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 |
|
|
Tru64 UNIX |
19200 database blocks |
