Skip Headers
Oracle® Database Administrator's Reference
10g Release 1 (10.1) for hp OpenVMS Alpha
Part No. B13738-01
  Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
Next
Next
 

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 2,147,483,647 bytes

Unlimited

Unlimited

Control files 192000 database blocks