Physical Database Limits
ItemType of LimitLimit Value Database Block Size Minimum 2048 bytes; must be a multiple of operating system physical block size Maximum Operating system dependent; never more than 32 KB Database Blocks Minimum in initial extent of a segment 2 blocks Maximum per datafile Platform dependent;. Typically 222-1 blocks Controlfiles Number of control files 1 minimum; 2 or more (on separate devices) strongly recommended size of a control file Dependent on operating system and database creation options; maximum of 20,000 x (database block size) Database files maximum per tablespace Operating system dependent; usually 1022 maximum per database 65533 May be less on some operating systems Limited also by size of database blocks and by the DB_FILES initialization parameter for a particular instance Database extents maximum 4 GB, regardless of the maximum file size allowed by the operating System Database File Size Maximum Operating System Dependent. Limited by Maximum Operating System File Size; typically 222 or 4M blocks MAXEXTENTS Default value Derived from tablespace default storage or DB_BLOCK_SIZE initialization parameter Maximum Unlimited Redo Log Files Maximum number of logfiles Limited by value of MAXLOGFILES parameter in the CREATE DATABASE statement Control file can be resized to allow more entries; ultimately an operating system limit Maximum number of logfiles per group Unlimited Redo Log File size Minimum size 50 KB Maximum size Operating system limit; typically 2 GB 64 K Number Tablespaces Maximum number per database of tablespaces can not exceed the number of database files, as each tablespace must include at Least One File
Process And Runtime Limits