Technical Specifications

Database capacity

Varying with the OS and hardware

Size of a table

32 TB

Size of data in each row

1 GB

Size of a single field in each record

1 GB

Number of records in each table

2⁴⁸

Number of columns in each table

250 to 1600 (varying with the field type)

Number of indexes in each table

Unlimited

Number of columns contained in a composite index

32

Database name length

64

Object name length (excluding the database name)

64

Number of constraints in each table

Unlimited

Number of concurrent connections

10000

Number of partitions in a partitioned table

32768

Size of each partition in a partitioned table

32 TB

Number of records in each partition of a partitioned table

2⁵⁵

Maximum LOB capacity

1 GB minus 8203 bytes

Maximum length of SQL text

1048576 bytes