Oracle Database Limits

客官°小女子只卖身不卖艺 2022-08-14 01:45 119阅读 0赞

Author:Skate

Time:2014/11/19

# Logical Database Limits(10.2) #

<table title="Logical Database Limits"> 
 <thead> 
  <tr> 
   <th>Item</th> 
   <th>Type</th> 
   <th>Limit</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <th><code>CREATE MATERIALIZED VIEW</code> definition</th> 
   <td>Maximum size</td> 
   <td>64K Bytes</td> 
  </tr> 
  <tr> 
   <th><code>GROUP BY</code> clause</th> 
   <td>Maximum length</td> 
   <td>The <code>GROUP BY</code> expression and all of the nondistinct aggregate functions (for example, <code>SUM</code>, <code>AVG</code>) must fit within a single database block.</td> 
  </tr> 
  <tr> 
   <th>Indexes</th> 
   <td>Maximum per table</td> 
   <td>Unlimited</td> 
  </tr> 
  <tr> 
   <th>total size of indexed column</th> 
   <td>75% of the database block size minus some overhead</td> 
  </tr> 
  <tr> 
   <th>Columns</th> 
   <td>Per table</td> 
   <td><code>1000</code> columns maximum</td> 
  </tr> 
  <tr> 
   <th>Per index (or clustered index)</th> 
   <td><code>32</code> columns maximum</td> 
  </tr> 
  <tr> 
   <th>Per bitmapped index</th> 
   <td><code>30</code> columns maximum</td> 
  </tr> 
  <tr> 
   <th>Constraints</th> 
   <td>Maximum per column</td> 
   <td>Unlimited</td> 
  </tr> 
  <tr> 
   <th>Subqueries</th> 
   <td>Maximum levels of subqueries in a SQL statement</td> 
   <td>Unlimited in the <code>FROM</code> clause of the top-level query <p><code>255</code> subqueries in the <code>WHERE</code> clause</p> </td> 
  </tr> 
  <tr> 
   <th>Partitions</th> 
   <td>Maximum length of linear partitioning key</td> 
   <td><code>4</code> KB - overhead</td> 
  </tr> 
  <tr> 
   <th>Maximum number of columns in partition key</th> 
   <td><code>16</code> columns</td> 
  </tr> 
  <tr> 
   <th>Maximum number of partitions allowed per table or index</th> 
   <td><code>1024K - 1</code></td> 
  </tr> 
  <tr> 
   <th>Rows</th> 
   <td>Maximum number per table</td> 
   <td>Unlimited</td> 
  </tr> 
  <tr> 
   <th>Stored Packages</th> 
   <td>Maximum size</td> 
   <td>PL/SQL and Developer/2000 may have limits on the size of stored procedures they can call. The limits typically range from <code>2000</code> to <code>3000</code> lines of code. <p><span>See Also:</span> Your PL/SQL or Developer/2000 documentation for details</p> </td> 
  </tr> 
  <tr> 
   <th>Trigger Cascade Limit</th> 
   <td>Maximum value</td> 
   <td>Operating system-dependent, typically <code>32</code></td> 
  </tr> 
  <tr> 
   <th>Users and Roles</th> 
   <td>Maximum</td> 
   <td><code>2,147,483,638</code></td> 
  </tr> 
  <tr> 
   <th>Tables</th> 
   <td>Maximum per clustered table</td> 
   <td><code>32</code> tables</td> 
  </tr> 
  <tr> 
   <th>Maximum per database</th> 
   <td>Unlimited</td> 
  </tr> 
 </tbody> 
</table>

# Logical Database Limits(11.1) #

<table title="Logical Database Limits"> 
 <thead> 
  <tr> 
   <th>Item</th> 
   <th>Type of Limit</th> 
   <th>Limit Value</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <th><code>GROUP BY</code> clause</th> 
   <td>Maximum length</td> 
   <td>The <code>GROUP BY</code> expression and all of the nondistinct aggregate functions (for example, <code>SUM</code>, <code>AVG</code>) must fit within a single database block.</td> 
  </tr> 
  <tr> 
   <th>Indexes</th> 
   <td>Maximum per table</td> 
   <td>Unlimited</td> 
  </tr> 
  <tr> 
   <th>Indexes</th> 
   <td>Total size of indexed column</td> 
   <td>75% of the database block size minus some overhead</td> 
  </tr> 
  <tr> 
   <th>Columns</th> 
   <td>Per table</td> 
   <td>1000 columns maximum</td> 
  </tr> 
  <tr> 
   <th>Columns</th> 
   <td>Per index (or clustered index)</td> 
   <td>32 columns maximum</td> 
  </tr> 
  <tr> 
   <th>Columns</th> 
   <td>Per bitmapped index</td> 
   <td>30 columns maximum</td> 
  </tr> 
  <tr> 
   <th>Constraints</th> 
   <td>Maximum per column</td> 
   <td>Unlimited</td> 
  </tr> 
  <tr> 
   <th>Subqueries</th> 
   <td>Maximum levels of subqueries in a SQL statement</td> 
   <td>Unlimited in the <code>FROM</code> clause of the top-level query <p><code>255</code> subqueries in the <code>WHERE</code> clause</p> </td> 
  </tr> 
  <tr> 
   <th>Partitions</th> 
   <td>Maximum length of linear partitioning key</td> 
   <td><code>4</code> KB - overhead</td> 
  </tr> 
  <tr> 
   <th>Partitions</th> 
   <td>Maximum number of columns in partition key</td> 
   <td>16 columns</td> 
  </tr> 
  <tr> 
   <th>Partitions</th> 
   <td>Maximum number of partitions allowed per table or index</td> 
   <td>1024K - 1</td> 
  </tr> 
  <tr> 
   <th>Rows</th> 
   <td>Maximum number per table</td> 
   <td>Unlimited</td> 
  </tr> 
  <tr> 
   <th>Stored Packages</th> 
   <td>Maximum size</td> 
   <td>PL/SQL and Developer/2000 may have limits on the size of stored procedures they can call. The limits typically range from <code>2000</code> to <code>3000</code> lines of code. <p><span>See Also:</span> Your PL/SQL or Developer/2000 documentation for details</p> </td> 
  </tr> 
  <tr> 
   <th>Trigger Cascade Limit</th> 
   <td>Maximum value</td> 
   <td>Operating system-dependent, typically <code>32</code></td> 
  </tr> 
  <tr> 
   <th>Users and Roles</th> 
   <td>Maximum</td> 
   <td><code>2,147,483,638</code></td> 
  </tr> 
  <tr> 
   <th>Tables</th> 
   <td>Maximum per clustered table</td> 
   <td>32 tables</td> 
  </tr> 
  <tr> 
   <th>Tables</th> 
   <td>Maximum per database</td> 
   <td>Unlimited</td> 
  </tr> 
 </tbody> 
</table>

\--------end---------