Monday, April 4, 2011

Oracle Database file Limits on various OS

Database Limits

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


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

No comments: