相关链接

Oracle进程和运行时限制

<table class="MsoNormalTable" style="margin-left: 4.65pt; border-collapse: collapse;" width="602" height="1461" cellspacing="0" cellpadding="0" border="0"> <tbody> <tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:13.5pt"> <td style="width:152.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="203"> Item </td> <td style="width:277.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="369"> Type of Limit </td> <td style="width:164.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="219"> Limit Value </td> <td style="width:256.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="341"> 总结 </td> </tr> <tr style="mso-yfti-irow:1;height:13.5pt"> <td style="width:152.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:13.5pt" width="203"> Instances per database </td> <td style="width:277.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:13.5pt" width="369"> Maximum number of cluster database instances per database </td> <td style="width:164.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:13.5pt" width="219"> Operating system-dependent </td> <td style="width:256.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:13.5pt" width="341"> Oracle中每个数据库的实例数量受限于操作系统 </td> </tr> <tr style="mso-yfti-irow:2;height:13.5pt"> <td style="width:152.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:13.5pt" width="203"> Locks </td> <td style="width:277.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:13.5pt" width="369"> Row-level </td> <td style="width:164.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:13.5pt" width="219"> Unlimited 无限制 </td> <td style="width:256.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:13.5pt" width="341"> Oracle中最多可拥有行级锁的数量不受限制 </td> </tr> <tr style="mso-yfti-irow:3;height:26.25pt"> <td style="width:152.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="203"> Locks </td> <td style="width:277.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="369"> Distributed Lock Manager </td> <td style="width:164.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="219"> Operating system dependent 操作系统相关 </td> <td style="width:256.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="341"> Oracle中分布式锁管理器最大数量与操作系统相关 </td> </tr> <tr style="mso-yfti-irow:4;height:82.5pt"> <td style="width:152.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:82.5pt" width="203"> SGA size </td> <td style="width:277.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:82.5pt" width="369"> Maximum value </td> <td style="width:164.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:82.5pt" width="219"> Operating system-dependent; typically 2 to 4 GB for 32-bit operating systems, and > 4 GB for 64-bit operating systems 操作系统相关 32位操作系统4G 64位可大于4G </td> <td style="width:256.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:82.5pt" width="341" valign="bottom"> Oracle中SGA最大大小与操作系统相关 如果是32位系统最多为4G,64位系统可大于4G </td> </tr> <tr style="mso-yfti-irow:5;height:13.5pt"> <td style="width:152.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:13.5pt" width="203"> Advanced Queuing Processes </td> <td style="width:277.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:13.5pt" width="369"> Maximum per instance </td> <td style="width:164.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:13.5pt" width="219"> 10 </td> <td style="width:256.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:13.5pt" width="341"> Oracle中每个实例最多可以有10个高级队列进程 </td> </tr> <tr style="mso-yfti-irow:6;height:13.5pt"> <td style="width:152.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:13.5pt" width="203"> Job Queue Processes </td> <td style="width:277.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:13.5pt" width="369"> Maximum per instance </td> <td style="width:164.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:13.5pt" width="219"> 1000 </td> <td style="width:256.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:13.5pt" width="341"> Oracle中每个实例最多可以有1000个任务队列进程 </td> </tr> <tr style="mso-yfti-irow:7;height:13.5pt"> <td style="width:152.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:13.5pt" width="203"> I/O Slave Processes </td> <td style="width:277.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:13.5pt" width="369"> Maximum per background process (DBWR, LGWR, and so on) </td> <td style="width:164.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:13.5pt" width="219"> 15 </td> <td style="width:256.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:13.5pt" width="341"> Oracle中每个后台进程的IO从进程最多有15个 </td> </tr> <tr style="mso-yfti-irow:8;height:13.5pt"> <td style="width:152.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:13.5pt" width="203"> I/O Slave Processes </td> <td style="width:277.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:13.5pt" width="369"> Maximum per Backup session </td> <td style="width:164.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:13.5pt" width="219"> 15 </td> <td style="width:256.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:13.5pt" width="341"> Oracle中每个备份会话 </td> </tr> <tr style="mso-yfti-irow:9;height:93.75pt"> <td style="width:152.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:93.75pt" width="203"> Sessions </td> <td style="width:277.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:93.75pt" width="369"> Maximum per instance </td> <td style="width:164.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:93.75pt" width="219"> 216; limited by the PROCESSES and SESSIONS initialization parameters. 216 is 65536. 65536; 受限于PROCESS 和 SESSIONS初始化参数 </td> <td style="width:256.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:93.75pt" width="341"> Oracle中进程和会话数量的最大值受限于初始化参数 </td> </tr> <tr style="mso-yfti-irow:10;height:13.5pt"> <td style="width:152.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:13.5pt" width="203"> Global Cache Service Processes </td> <td style="width:277.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:13.5pt" width="369"> Maximum per instance </td> <td style="width:164.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:13.5pt" width="219"> 10 </td> <td style="width:256.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:13.5pt" width="341"> Oracle中每个实例最多可以有10个GCS进程 (译者注:这里应该是文档不严谨) </td> </tr> <tr style="mso-yfti-irow:11;height:81.0pt"> <td style="width:152.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:81.0pt" width="203"> Shared Servers </td> <td style="width:277.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:81.0pt" width="369"> Maximum per instance </td> <td style="width:164.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:81.0pt" width="219"> Unlimited within constraints set by the PROCESSES and SESSIONS initialization parameters, for instance 无限制,在设置PROCESSES和SESSIONS 初始化参数范围内 </td> <td style="width:256.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:81.0pt" width="341"> Oracle中shared server数量无限制,在设置PROCESSES和SESSIONS 初始化参数范围内 </td> </tr> <tr style="mso-yfti-irow:12;height:68.25pt"> <td style="width:152.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:68.25pt" width="203"> Dispatchers </td> <td style="width:277.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:68.25pt" width="369"> Maximum per instance </td> <td style="width:164.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:68.25pt" width="219"> Unlimited within constraints set by PROCESSES and SESSIONS initialization parameters, for instance 无限制,在设置PROCESSES和SESSIONS 初始化参数范围内 </td> <td style="width:256.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:68.25pt" width="341" valign="bottom"> Oracle中Dispatchers数量无限制 在设置PROCESSES和SESSIONS 初始化参数范围内 </td> </tr> <tr style="mso-yfti-irow:13;height:68.25pt"> <td style="width:152.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:68.25pt" width="203"> Parallel Execution Slaves </td> <td style="width:277.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:68.25pt" width="369"> Maximum per instance </td> <td style="width:164.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:68.25pt" width="219"> Unlimited within constraints set by PROCESSES and SESSIONS initialization parameters, for instance 无限制,在设置PROCESSES和SESSIONS 初始化参数范围内 </td> <td style="width:256.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:68.25pt" width="341" valign="bottom"> Oracle中并行执行从进程数量无限制 在设置PROCESSES和SESSIONS 初始化参数范围内 </td> </tr> <tr style="mso-yfti-irow:14;height:68.25pt"> <td style="width:152.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:68.25pt" width="203"> Backup Sessions </td> <td style="width:277.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:68.25pt" width="369"> Maximum per instance </td> <td style="width:164.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:68.25pt" width="219"> Unlimited within constraints set by PROCESSES and SESSIONS initialization parameters, for instance 无限制,在设置PROCESSES和SESSIONS 初始化参数范围内 </td> <td style="width:256.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:68.25pt" width="341"> Oracle中备份会话数量无限制,在设置PROCESSES和SESSIONS 初始化参数范围内 </td> </tr> <tr style="mso-yfti-irow:15;mso-yfti-lastrow:yes;height:13.5pt"> <td style="width:152.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:13.5pt" width="203"> Services </td> <td style="width:277.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:13.5pt" width="369"> Maximum per instance </td> <td style="width:164.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:13.5pt" width="219"> 1024 </td> <td style="width:256.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:13.5pt" width="341"> Oracle中每个实例服务最可可以有1024个 </td> </tr> </tbody></table>

上一篇：Oracle分页写法大全|下一篇：Oracle逻辑数据库限制