H Database Limits

This appendix describes database limits.

H.1 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

MAXLOGFILES

16

255

MAXLOGMEMBERS

2

5

MAXLOGHISTORY

100

65534

MAXDATAFILES

30

65534

MAXINSTANCES

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 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