A Database Limits

This appendix describes the database limits.

A.1 Database Limits

Table A-1 lists the default and maximum values for parameters in a CREATE DATABASE or CREATE CONTROLFILE statement.

Note:

Interdependencies between these parameters may affect allowable values.

Table A-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 A-2 lists the Oracle Database file size limits in bytes.

Table A-2 File Size Limits

File Type Maximum SIze

Data files

4,194,303 multiplied by the value of the DB_BLOCK_SIZE parameter

Import/Export files and SQL*Loader files

Unlimited

Control files

192000 database blocks