| Oracle® Database Administrator's Reference 10g Release 2 (10.2) for UNIX-Based Operating Systems Part Number B15658-01 |
|
|
View PDF |
| Oracle® Database Administrator's Reference 10g Release 2 (10.2) for UNIX-Based Operating Systems Part Number B15658-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 |
|---|---|---|
MAXLOGFILES |
16 | 255 |
MAXLOGMEMBERS |
2 | 5 |
MAXLOGHISTORY |
100 | 65534 |
MAXDATAFILES |
30 | 65534 |
MAXINSTANCES |
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 DB_BLOCK_SIZE parameter |
| 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 |
