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
|
232 x (8 KB/Row width). At the code level, a single table can contain a maximum of 232 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 232 x 8 = 235. 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
|
255
|
Maximum LOB capacity
|
(1 GB – 8203) B
|
Maximum length of SQL text
|
1048576 B
|
