相关链接

Oracle物理数据库限制

<table class="MsoNormalTable" style="margin-left: 4.65pt; border-collapse: collapse;" width="597" height="2755" cellspacing="0" cellpadding="0" border="0"> <tbody> <tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:13.5pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;mso-border-alt:
 solid windowtext .5pt;background:#3F3F3F;padding:0cm 5.4pt 0cm 5.4pt;
 height:13.5pt" width="192"> Item </td> <td style="width:180.0pt;border:solid windowtext 1.0pt;border-left:
 none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:#3F3F3F;padding:0cm 5.4pt 0cm 5.4pt;
 height:13.5pt" width="240"> Type of Limit </td> <td style="width:143.0pt;border-top:solid windowtext 1.0pt;
 border-left:none;border-bottom:solid windowtext 1.0pt;border-right:none;
 mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 background:#3F3F3F;padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" width="191"> Limit Value </td> <td style="width:119.0pt;background:#3F3F3F;padding:0cm 5.4pt 0cm 5.4pt;
 height:13.5pt" width="159"> 含义 </td> <td style="height:13.5pt;border:none" width="0" height="18"> </td> </tr> <tr style="mso-yfti-irow:1;height:67.5pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:67.5pt" width="192"> Database Block Size </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:67.5pt" width="240"> Minimum </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:67.5pt" width="191"> 2048 bytes; must be a multiple of operating system physical block size 2K,必须是操作系统块的整数倍 </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;mso-border-alt:
 solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:67.5pt" width="159"> Oracle 数据块最小为2K 必须为系统块的整数倍 </td> <td style="height:67.5pt;border:none" width="0" height="90"> </td> </tr> <tr style="mso-yfti-irow:2;height:53.25pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:53.25pt" width="192"> Database Block Size </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:53.25pt" width="240"> Maximum </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:53.25pt" width="191"> Operating system dependent; never more than 32 KB 与操作系统相关,最高不超过32K </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:53.25pt" width="159"> Oracle 数据块最小为32K必须为系统块的整数倍 </td> <td style="height:53.25pt;border:none" width="0" height="71"> </td> </tr> <tr style="mso-yfti-irow:3;height:26.25pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:26.25pt" width="192"> Database Blocks </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:26.25pt" width="240"> Minimum in initial extent of a segment </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:26.25pt" width="191"> 2 blocks 2个块 </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:26.25pt" width="159"> Oracle 最小的初始化区包含两个块 </td> <td style="height:26.25pt;border:none" width="0" height="35"> </td> </tr> <tr style="mso-yfti-irow:4;height:52.5pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:52.5pt" width="192"> Database Blocks </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:52.5pt" width="240"> Maximum per datafile </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:52.5pt" width="191"> Platform dependent; typically 222 - 1 blocks 平台相关,典型为2的22次方-1 4194303 </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:52.5pt" width="159"> Oracle 数据文件最大包含222-1个块 </td> <td style="height:52.5pt;border:none" width="0" height="70"> </td> </tr> <tr style="mso-yfti-irow:5;height:66.75pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:66.75pt" width="192"> Controlfiles </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:66.75pt" width="240"> Number of control files </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:66.75pt" width="191"> 1 minimum; 2 or more (on separate devices) strongly recommended 最小一个,可有2个及以上,强烈推荐 </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:66.75pt" width="159"> Oracle 最少有一个控制文件 强烈推荐两个以上 </td> <td style="height:66.75pt;border:none" width="0" height="89"> </td> </tr> <tr style="mso-yfti-irow:6;height:53.25pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:53.25pt" width="192"> Controlfiles </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:53.25pt" width="240"> Size of a control file </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:53.25pt" width="191"> Maximum of 201031680 logical blocks 最多可以有 201031680个逻辑块 </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:53.25pt" width="159"> Orace控制文件最多可以有201031680个逻辑块 </td> <td style="height:53.25pt;border:none" width="0" height="71"> </td> </tr> <tr style="mso-yfti-irow:7;height:39.75pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:39.75pt" width="192"> Database files </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:39.75pt" width="240"> Maximum per tablespace </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:39.75pt" width="191"> Operating system dependent; usually 1022 与操作系统有关,通常为1022个 </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:39.75pt" width="159"> Oracle最多可以包含数据文件的数量与操作系统相关,通常为1022个 </td> <td style="height:39.75pt;border:none" width="0" height="53"> </td> </tr> <tr style="mso-yfti-irow:8;height:39.75pt"> <td rowspan="3" style="width:144.0pt;border:solid windowtext 1.0pt;
 border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
 solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background:
 white;padding:0cm 5.4pt 0cm 5.4pt;height:39.75pt" width="192"> Database files </td> <td rowspan="3" style="width:180.0pt;border-top:none;border-left:
 none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:39.75pt" width="240"> Maximum per database </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:39.75pt" width="191"> 65533 </td> <td rowspan="3" style="width:119.0pt;border:solid windowtext 1.0pt;
 border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
 solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
 0cm 5.4pt 0cm 5.4pt;height:39.75pt" width="159"> Oracle数据库最多可包含65533个数据文件,在某些操作系统上会小些. 对于一个特定的实例 受限于DB_FILES的初始化参数和操作系统 </td> <td style="height:39.75pt;border:none" width="0" height="53"> </td> </tr> <tr style="mso-yfti-irow:9;height:39.75pt"> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:39.75pt" width="191"> May be less on some operating systems 在某些操作系统上会小些 </td> <td style="height:39.75pt;border:none" width="0" height="53"> </td> </tr> <tr style="mso-yfti-irow:10;height:126.0pt"> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:126.0pt" width="191"> Limited also by size of database blocks and by the DB_FILES initialization parameter for a particular instance 对于特定的实例,也受数据库大小和DB_FILES初始化参数的限制 </td> <td style="height:126.0pt;border:none" width="0" height="168"> </td> </tr> <tr style="mso-yfti-irow:11;height:98.25pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:98.25pt" width="192"> Database extents </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:98.25pt" width="240"> Maximum per dictionary managed tablespace </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:98.25pt" width="191"> 4 GB * physical block size (with K/M modifier); 4 GB (without K/M modifier) 如果使用K/M 修饰词则为4G*物理块大小.如不使用则为4GB </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:98.25pt" width="159"> Oracle 字典管理的表空间在使用K/M修饰词的情况下为4G*物理块大小,如果不使用修饰词则为4G </td> <td style="height:98.25pt;border:none" width="0" height="131"> </td> </tr> <tr style="mso-yfti-irow:12;height:120.0pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:120.0pt" width="192"> Database extents </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:120.0pt" width="240"> Maximum per locally managed (uniform) tablespace </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:120.0pt" width="191"> 2 GB * physical block size (with K/M modifier); 2 GB (without K/M modifier) 如果使用K/M 修饰词则为2G*物理块大小.如不使用则为2GB </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:120.0pt" width="159"> Oracle 本地管理的表空间在不使用K/M修饰词的情况下为2G,如使用则为2GB*物理块大小 </td> <td style="height:120.0pt;border:none" width="0" height="160"> </td> </tr> <tr style="mso-yfti-irow:13;height:51.75pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:51.75pt" width="192"> Database file size </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:51.75pt" width="240"> Maximum </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:51.75pt" width="191"> Operating system dependent. Limited by maximum operating system file size. See the Bigfile Tablespaces and Smallfile (traditional) Tablespaces rows for more information about the maximum database file size in these types of tablespaces. 依赖于操作系统.受限于操作体统支持的最大文件 </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:51.75pt" width="159"> Oracle 最大数据文件大小依赖于操作系统.受限于操作体统支持的最大文件大小 </td> <td style="height:51.75pt;border:none" width="0" height="69"> </td> </tr> <tr style="mso-yfti-irow:14;height:66.75pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:66.75pt" width="192"> MAXEXTENTS </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:66.75pt" width="240"> Default value </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:66.75pt" width="191"> Derived from tablespace default storage or DB_BLOCK_SIZE initialization parameter 采自表空间默认存储参数或DB_BLOCK_SIZE初始化参数 </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:66.75pt" width="159"> Oracle 最大区衍生自表空间某人存储参数或 初始化参数DB_BLOCK_SIZE </td> <td style="height:66.75pt;border:none" width="0" height="89"> </td> </tr> <tr style="mso-yfti-irow:15;height:35.25pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:35.25pt" width="192"> MAXEXTENTS </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:35.25pt" width="240"> Maximum </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:35.25pt" width="191"> Unlimited 无限制 </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:35.25pt" width="159"> Oracle 最大的区无限制 </td> <td style="height:35.25pt;border:none" width="0" height="47"> </td> </tr> <tr style="mso-yfti-irow:16;height:108.0pt"> <td rowspan="2" style="width:144.0pt;border:solid windowtext 1.0pt;
 border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
 solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background:
 white;padding:0cm 5.4pt 0cm 5.4pt;height:108.0pt" width="192"> Redo Log Files </td> <td rowspan="2" style="width:180.0pt;border-top:none;border-left:
 none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:108.0pt" width="240"> Maximum number of logfiles </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:108.0pt" width="191"> Limited by value of MAXLOGFILES parameter in the CREATE DATABASE statement Oracle 最多可包含的redolog 数量取决于CREATE DATABASE语句是指定的MAXLOGFILES参数 </td> <td rowspan="2" style="width:119.0pt;border:solid windowtext 1.0pt;
 border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
 solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
 0cm 5.4pt 0cm 5.4pt;height:108.0pt" width="159"> Oracle 最多可包含的redolog 数量取决于CREATE DATABASE语句是指定的MAXLOGFILES参数,可以通过重置控制文件以扩展允许的数量,最终取决于操作系统 </td> <td style="height:108.0pt;border:none" width="0" height="144"> </td> </tr> <tr style="mso-yfti-irow:17;height:79.5pt"> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:79.5pt" width="191"> Control file can be resized to allow more entries; ultimately an operating system limit 可以通过重置控制文件以扩展允许的数量,最终取决于操作系统 </td> <td style="height:79.5pt;border:none" width="0" height="106"> </td> </tr> <tr style="mso-yfti-irow:18;height:66.0pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:66.0pt" width="192"> Redo Log Files </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:66.0pt" width="240"> Maximum number of logfiles per group </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:66.0pt" width="191"> Unlimited 无限制 </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:66.0pt" width="159"> Oracle 每个日志组包含的日志文件个数没有限制 </td> <td style="height:66.0pt;border:none" width="0" height="88"> </td> </tr> <tr style="mso-yfti-irow:19;height:27.75pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:27.75pt" width="192"> Redo Log File Size </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.75pt" width="240"> Minimum size </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:27.75pt" width="191"> 4 MB 最小为4M </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:27.75pt" width="159"> Oracle redo日志文件最小为4M </td> <td style="height:27.75pt;border:none" width="0" height="37"> </td> </tr> <tr style="mso-yfti-irow:20;height:54.0pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:54.0pt" width="192"> Redo Log File Size </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:54.0pt" width="240"> Maximum Size </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:54.0pt" width="191"> Operating system limit; typically 2 GB 操作系统限制,典型为2G </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:54.0pt" width="159"> Oracle redo日志文件最大大小受操作系统限制 典型为2G </td> <td style="height:54.0pt;border:none" width="0" height="72"> </td> </tr> <tr style="mso-yfti-irow:21;height:15.6pt"> <td rowspan="2" style="width:144.0pt;border:solid windowtext 1.0pt;
 border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
 solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background:
 white;padding:0cm 5.4pt 0cm 5.4pt;height:15.6pt" width="192"> Tablespaces </td> <td rowspan="2" style="width:180.0pt;border-top:none;border-left:
 none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:15.6pt" width="240"> Maximum number per database </td> <td rowspan="2" style="width:143.0pt;border:none;border-bottom:solid black 1.0pt;
 mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
 mso-border-bottom-alt:solid black .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:15.6pt" width="191"> 64 K Number of tablespaces cannot exceed the number of database files because each tablespace must include at least one file 表空间数量不能多于数据文件数量,因为每个表空间最少包含一个数据文件 </td> <td rowspan="2" style="width:119.0pt;border:solid windowtext 1.0pt;
 border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
 solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
 0cm 5.4pt 0cm 5.4pt;height:15.6pt" width="159"> Oracle 最多可以有64K个表空间.同时表空间数量不能多于数据文件数量 </td> <td style="height:15.6pt;border:none" width="0" height="21"> </td> </tr> <tr style="mso-yfti-irow:22;height:15.6pt"> <td style="height:15.6pt;border:none" width="0" height="21"> </td> </tr> <tr style="mso-yfti-irow:23;height:204.75pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:204.75pt" width="192"> Bigfile Tablespaces </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:204.75pt" width="240"> Number of blocks </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:204.75pt" width="191"> A bigfile tablespace contains only one datafile or tempfile, which can contain up to approximately 4 billion ( 232 ) blocks. The maximum size of the single datafile or tempfile is 128 terabytes (TB) for a tablespace with 32 K blocks and 32 TB for a tablespace with 8 K blocks. 一个bigfile 表空间只能包含一个数据文件或临时文件,文件大致可以包含4 billion ( 232 ) 个块.如果表空间块大小为32K则为128T,如果8K则为32T </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:204.75pt" width="159"> Oracle bigfile 表空间可以包含232个块.如果为8K最大为32T,如果为32K最大128T. </td> <td style="height:204.75pt;border:none" width="0" height="273"> </td> </tr> <tr style="mso-yfti-irow:24;height:179.25pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:179.25pt" width="192"> Smallfile (traditional) Tablespaces </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:179.25pt" width="240"> Number of blocks </td> <td style="width:143.0pt;border:none;border-bottom:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:179.25pt" width="191"> A smallfile tablespace is a traditional Oracle tablespace, which can contain 1022 datafiles or tempfiles, each of which can contain up to approximately 4 million (222) blocks. 一个smallfile表空间是Oracle传统的表空间模式,可以包含1022个数据文件或者临时文件,每个文件可以包含4million (222) 个块 </td> <td style="width:119.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
 height:179.25pt" width="159"> Oracle 传统表空间最多可以有1022个数据文件或临时文件,每个文件可以包含222个块 </td> <td style="height:179.25pt;border:none" width="0" height="239"> </td> </tr> <tr style="mso-yfti-irow:25;mso-yfti-lastrow:yes;height:70.5pt"> <td style="width:144.0pt;border:solid windowtext 1.0pt;border-top:
 none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt;
 mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt;
 height:70.5pt" width="192"> External Tables file </td> <td style="width:180.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:70.5pt" width="240"> Maximum size </td> <td style="width:143.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 background:white;padding:0cm 5.4pt 0cm 5.4pt;height:70.5pt" width="191"> Dependent on the operating system. 取决于操作系统 An external table can be composed of multiple files. 一个外部表可以包含多个文件 </td> <td style="width:119.0pt;border-top:none;border-left:none;
 border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
 mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
 padding:0cm 5.4pt 0cm 5.4pt;height:70.5pt" width="159"> Oracle外部表文件最大尺寸取决于操作系统.一个外部表可以包含多个文件. </td> <td style="height:70.5pt;border:none" width="0" height="94"> </td> </tr> </tbody></table>

上一篇：Oracle逻辑数据库限制|下一篇：为方便大家学习,特公布标准实验环境