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³² x (8 KB/Row width). At the code level, a single table can contain a maximum of 2³² pages, and the size of each page is 8 KB. Assume that the current data row width is 1 KB. The number of records in a single table is 2³² x 8 = 2³⁵. The current page size is 8 KB, and each page contains eight rows of data.

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

32767 (range partition)/64 (hash/list partition)

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 – 8203) B

Maximum length of SQL text

1048576 B