1. Using Oracle NoSQL Database Cloud Service
  2. Developing in Oracle Cloud
  3. Oracle NoSQL Database Cloud Service Limits

Oracle NoSQL Database Cloud Service Limits

Current limits that apply to Oracle NoSQL Database Cloud Service.

Scope Description Value

Table

Maximum total storage size per tenant. The total space used for one or more tables cannot exceed this value.

5 TB

Table Names

Maximum number of characters, allowed characters, and initial character.

Table names can have a maximum of 256 characters. All names must begin with a letter (a–z, A–Z). Subsequent characters can be letters (a–z, A–Z), digits (0–9), or underscore.

Table

Maximum read and write throughput.

40,000 read units and 20,000 write units per table.

Tenant

Maximum number of tables

30

Table

Maximum number columns

50

Table

Maximum number of table schema updates

100

Table

Maximum number of indexes

5

Table

Maximum number of changes for throughput and storage limits

Oracle allows:

  • Unlimited number of throughput and storage increases per day

  • Up to four throughput or storage decreases per 24-hour period.
Index Names Maximum number of characters, allowed characters, and initial character.

Index names can have a maximum of 64 characters. All names must begin with a letter (a–z, A–Z). Subsequent characters can be letters (a–z, A–Z), digits (0–9), or underscore.

Request

Maximum number of individual operations per WriteMultiple request.

50

Request

Maximum data size for WriteMultiple request.

25 MB
Field Names Maximum number of characters, allowed characters, and initial character. Field names can have a maximum of 64 characters. All names must begin with a letter (a–z, A–Z). Subsequent characters can be letters (a–z, A–Z), digits (0–9), or underscore.

Field

Maximum index key size.

64 bytes

Field

Maximum primary key size.

64 bytes

Row

Maximum row size.

512 KB

Query

Maximum query string length.

10 KB

Tenant

Maximum supported rate of DDL operations.

4 per minute

Tenant

Maximum values for throughput and data storage resources.

Per tenant, Oracle allows:

  • A maximum of 100,000 read units

  • A maximum of 40,000 write units

Oracle allows a maximum storage size of 5-TB per-tenant. The tenant can have a single table with storage size of 5 TB, in which case the tenant is not able to create another table. Or have multiple tables and ensure that the data within all these tables is within the maximum storage size of 5 TB.