Skip Headers
Oracle® Database Administrator's Reference
10g Release 2 (10.2) for UNIX-Based Operating Systems

Part Number B15658-08
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

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