|
Oracle® Database Administrator's Reference
10g Release 1 (10.1) for UNIX Systems: AIX-Based Systems, Apple Mac OS X, hp HP-UX, hp Tru64 UNIX, Linux, and Solaris Operating System Part No. B10812-06 |
|
 Previous |
 Next |
|
Oracle® Database Administrator's Reference
10g Release 1 (10.1) for UNIX Systems: AIX-Based Systems, Apple Mac OS X, hp HP-UX, hp Tru64 UNIX, Linux, and Solaris Operating System Part No. B10812-06 |
|
|
Previous |
Next |
This appendix describes database limits specific to UNIX systems.
Table G-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 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 specific to UNIX.
Table G-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 | 16 TB |
| AIX, HP-UX, Linux, Solaris: 32-bit with 32-bit files | 2,147,483,647 bytes | |
| AIX, HP-UX, Linux, Solaris: 32-bit with 64-bit files | Unlimited | |
| AIX, HP-UX, Linux, Mac OS X, Solaris: 64-bit | Unlimited | |
| Control files | Solaris, HP-UX, Linux, Mac OS X | 20000 database blocks |
| AIX | 10000 database blocks | |
| Tru64 UNIX | 19200 database blocks |
