Oracle Database 10g Release 2 (10.2) Logical Database Limits

向右看齐 2023-10-05 10:02 8阅读 0赞

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

Note:

The limit on how long a SQL statement can be depends on many factors, including database configuration, disk space, and memory

Note:

When an object instance exists in memory, there is no fixed limit on the number of attributes in the object. But the maximum total amount of memory consumed by an object instance is 4 GB.When an object instance is inserted into a table, the attributes are exploded into separate columns in the table, and the Oracle 1000-column limit applies.