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