Parameter | Limit |
|---|---|
Maximum database size | 1,000 EB (exabytes) |
Maximum tables in a database | 1.1 billion |
Maximum files per database | 2 billion |
Maximum files per instance | Limit based on file systems. |
Maximum page size | 64 KB |
Maximum cache buffers | 4 GB on 32-bit systems 16 EB on 64-bit systems Limited by hardware/OS memory architecture. |
Maximum rows per table | 34.5 trillion |
Maximum row size per table | 256 KB Limit does not include LOBs. |
Maximum fields (columns) per table | 1024 |
Maximum indexes per table | 126 |
Maximum file size per index | 512 GB |
Maximum fields (columns) per index | 32 |
Maximum integer size | 64 bits |
Maximum decimal precision | 39 digits |
Maximum float precision | Hardware dependent |
Maximum length of a character field | 32,000 bytes If II_CHARSETxx=UTF8,16,000 bytes |
Maximum length of a varchar field | 32,000 bytes If II_CHARSETxx=UTF8,16,000 bytes |
Maximum size of a CLOB | 2 GB |
Maximum size of a BLOB | 2 GB |
Maximum size of an SQL statement | Unlimited |
Maximum members in an IN list | Unlimited |
Maximum logical operators in a WHERE clause | Unlimited |
Maximum join conditions | Unlimited |
Maximum tables in a join statement | 126 |
Unicode support | UTF-8 and UCS-2 (UTF-16 without surrogate support) |
XML support | Consume and publish |