| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Maximum Number of Tablespace on 8.1.7.2
Thanks a lot
But I do not belive nulber of tablespace is 2 BILLION.
I spent time to find this
Oracle8i Reference
Release 2 (8.1.6)
Part Number A76961-01 ..\..\products.htm <../../products.htm> Library <../../products.htm> ..\index.htm <../index.htm> Product <../index.htm> toc.htm <toc.htm> Contents <toc.htm> index.htm <index.htm>Index <index.htm>
ch42.htm <ch42.htm> ch42.htm <ch42.htm> ch4.htm <ch4.htm> ch4.htm <ch4.htm> ch44.htm <ch44.htm> ch44.htm <ch44.htm> Database Limits, 3 of 5
Physical Database Limits
Item Type of Limit Limit 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
2 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 LOG_FILES initialization parameter or 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
50K bytes
Maximum size
Operating system limit; typically 2GB.
Tablespaces
Maximum number per database
64K
Number of tablespaces cannot exceed the number of database files, as each
tablespace must include at least one file.
ch42.htm <ch42.htm> ch42.htm <ch42.htm> ch4.htm <ch4.htm> ch4.htm <ch4.htm> ch44.htm <ch44.htm> ch44.htm <ch44.htm> ..\..\dcommon/html/cpyr.htm <../../dcommon/html/cpyr.htm> Copyright © 1996-2000, Oracle Corporation. <../../dcommon/html/cpyr.htm> All Rights Reserved. ..\..\products.htm <../../products.htm> Library <../../products.htm> ..\index.htm <../index.htm> Product <../index.htm> toc.htm <toc.htm> Contents <toc.htm> index.htm <index.htm>Index <index.htm>
-----Message d'origine----- De: James Damiano [mailto:jadam_at_nhes.state.nh.us] Date: mardi 6 août 2002 21:19 À: Multiple recipients of list ORACLE-L Objet: Re:Maximum Number of Tablespace on 8.1.7.2 Gilbert, The maximum number of tablespaces is ~=2 Billion. The maximum number of datafiles per tablespace is 1022. See the following link: http://www.itsystems.lv/gints/oracle_limits.htm Jim Damiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano INET: jadam_at_nhes.state.nh.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Aug 07 2002 - 04:43:30 CDT
 |
 |