| Oracle® Database Administrator’s Reference 10g Release 1 (10.1) for UNIX Systems: AIX-Based Systems, hp HP-UX PA-RISC (64-bit), hp Tru64 UNIX, Linux x86, and Solaris Operating System (SPARC) Part No. B10812-01 |
|
 |
 |
| Oracle® Database Administrator’s Reference 10g Release 1 (10.1) for UNIX Systems: AIX-Based Systems, hp HP-UX PA-RISC (64-bit), hp Tru64 UNIX, Linux x86, and Solaris Operating System (SPARC) Part No. B10812-01 |
|
|
|
This appendix describes the database limits. It contains the following section:
Table F-1 lists the default and maximum values for parameters in a CREATE DATABASE or CREATE CONTROLFILE statement.
|
Note: Interdependencies between these parameters might affect allowable values. |
Table F-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 F-2 lists the Oracle Database file size limits in bytes specific to UNIX.
Table F-2 File Size Limits
| File Type | Operating System | Maximum SIze |
|---|---|---|
| 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
AIX, HP-UX, Linux, Solaris: 32-bit with 32-bit files AIX, HP-UX, Linux, Solaris: 32-bit with 64-bit files AIX, HP-UX, Linux, Solaris: 64-bit |
16 TB
2,147,483,647 bytes Unlimited Unlimited |
| Control files | Solaris, HP-UX, Linux | 20000 database blocks |
| AIX | 10000 database blocks | |
| Tru64 UNIX | 19200 database blocks |
