Miscellaneous System Limits
|
Parameter |
Value |
|
Maximum number of combined databases and users. |
4.2 x 109 |
|
Maximum number of database objects per system lifetime. A database object is any object whose definition is recorded in DBC.TVM. Because the system does not reuse DBC.TVM IDs, this means that a maximum of 1,073,741,824 such objects can be created over the lifetime of any given system. At the rate of creating one new database object per minute, it would take 2,042 years to use 1,073,741,824 unique IDs. |
1,073,741,824 |
|
Maximum size for a table header. |
1 MB |
|
Maximum size of table header cache. |
8 x 106 bytes |
|
Maximum size of a response spool row. |
64KB |
|
Maximum number of change logs that can be specified for a system at any point in time. |
1,000,000 |
|
Maximum number of locks that can be placed on aggregate online archive logging tables, databases, or both per request. The maximum number of locks that can be placed per LOGGING ONLINE ARCHIVE ON request is fixed at 25,000 and cannot be altered. |
25,000 |
|
Maximum number of 64KB parse tree segments allocated for parsing requests. |
12,000 |
|
Maximum number of nodes per system configuration. Limits on vprocs of each type restrict systems with a large number of nodes to fewer vprocs per node. Systems with the maximum vprocs per node cannot approach the maximum number of nodes. |
1,024 |