Skip Headers
Oracle® Database Administrator's Reference
11g Release 2 (11.2) for Linux and UNIX-Based Operating Systems

E10839-21
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

F Database Limits

This appendix describes database limits.

F.1 Database Limits

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

1055


Table F-2 lists the Oracle Database file size limits in bytes.

Table F-2 File Size Limits

File Type Platform File size limit

Data files

Any

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

Import/Export files and SQL*Loader files

AIX, HP-UX, Linux, and Solaris: 32-bit with 32-bit files

2,147,483,647 bytes

 

AIX, HP-UX, Linux, and Solaris: 64-bit files

Unlimited

Note: File size is limited by limits allowed by the operating system on different file systems.

Control files

HP-UX, Linux, AIX, and Solaris

25000 control file blocks with a block size of 4096 bytes.