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