Oracle NoSQL Database Cloud Service Subscription

Learn how to manage Oracle NoSQL Database Cloud Service subscriptions and it's users.

This article has the following topics:

Service Limits

Oracle NoSQL Database Cloud Service has various default limits. Whenever you create an Oracle NoSQL Database Cloud Service table, the system ensures that your requests are within the bounds of the specified limit. When creating On Demand capacity tables, the On Demand Capacity max limits will be used during the validation.

This table lists the Oracle NoSQL Database Cloud Service limits that you can reference. For detailed list of service limits, see Oracle NoSQL Database Cloud Service Limits.

Resource Monthly Universal Credits Pay-as-You-Go or Promo
Read Units 100,000 units 100,000 units
Write Units 40,000 units 40,000 units
Table Size 5,000 GB 5,000 GB

You can increase your service limits by submitting a request either from Limits, Quotas, and Usage page in Oracle Cloud Infrastructure Console or using the TableRequest API.

See About Service Limits and Usage in Oracle Cloud Infrastructure Documentation.

Service Quotas

You can use quotas to determine how other users allocate Oracle NoSQL Database Cloud Service resources across compartments in Oracle Cloud Infrastructure. A compartment is a collection of related resources (such as instances, virtual cloud networks, block volumes) that can be accessed only by certain groups that have been given permission by an administrator. Whenever you create an Oracle NoSQL Database Cloud Service table or scale up the provisioned throughput or storage, the system ensures that your requests are within the bounds of the quota for that compartment.

This table lists the Oracle NoSQL Database Cloud Service quotas that you can reference.

Name Scope Description
read-unit-count Regional Read Unit Count
write-unit-count Regional Write Unit Count
table-size-gb Regional Table Size (GB)

You can set quotas using the Console or API. You can execute quota statements from the Quota Policies page under the Governance option in Oracle Cloud Infrastructure Console.

Example Quota Statements for Oracle NoSQL Database Cloud Service

  • Limit the number of Oracle NoSQL Database Cloud Service read units that users can allocate to tables they create in my_compartment to 20,000.
    set nosql quota read-unit-count to 20000 in compartment my_compartment
  • Limit the number of Oracle NoSQL Database Cloud Service write units that users can allocate to tables they create in my_compartment to 5,000.
    set nosql quota write-unit-count to 5000 in compartment my_compartment
  • Limit the maximum storage space of Oracle NoSQL Database Cloud Service that users can allocate to tables they create in my_compartment to 1,000 GB.
    set nosql quota table-size-gb to 1000 in compartment my_compartment

See About Compartment Quotas in Oracle Cloud Infrastructure Documentation.

Service Events

Actions that you perform on Oracle NoSQL Database Cloud Service tables emit events.

You can define rules that trigger a specific action when an event occurs. For example, you might define a rule that sends a notification to administrators when someone drops a table. See Overview of Events and Get Started with Events in Oracle Cloud Infrastructure Documentation.

This table lists the Oracle NoSQL Database Cloud Service events that you can reference.

Friendly Name Event Type
Alter Table Begin
com.oraclecloud.nosql.altertable.begin
Alter Table End
com.oraclecloud.nosql.altertable.end
Change Table Compartment Begin
com.oraclecloud.nosql.changecompartment.begin
Change Table Compartment End
com.oraclecloud.nosql.changecompartment.end
Create Index Begin
com.oraclecloud.nosql.createindex.begin
Create Index End
com.oraclecloud.nosql.createindex.end
Create Table Begin
com.oraclecloud.nosql.createtable.begin
Create Table End
com.oraclecloud.nosql.createtable.end
Drop Index Begin
com.oraclecloud.nosql.dropindex.begin
Drop Index End
com.oraclecloud.nosql.dropindex.end
Drop Table Begin
com.oraclecloud.nosql.droptable.begin
Drop Table End
com.oraclecloud.nosql.droptable.end

Example

This example shows information associated with the event Create Table Begin:
{
  "cloudEventsVersion": "0.1",
  "contentType": "application/json",
  "source": "nosql",
  "eventID": "<unique_ID>",
  "eventType": "com.oraclecloud.nosql.createtable.begin",
  "eventTypeVersion": "<version>",
  "eventTime": "2019-12-30T00:52:01.343Z",
  "data": {
    "additionalDetails": {},
    "availabilityDomain": "<availability_domain>",
    "compartmentId": "ocid1.compartment.oc1..<unique_ID>",
    "compartmentName": "my_compartment",
    "freeformTags": {
    "key":"value"
     },
    "resourceId": "ocid1.nosqltable.oc1..<unique_ID>",
    "resourceName": "my_nosql_table"
  },
  "extensions": {
    "compartmentId": "ocid1.compartment.oc1..<unique_ID>"
  }
}

Service Metrics

Learn about the metrics emitted by the metric namespace oci_nosql (Oracle NoSQL Database Cloud Service).

Metrics for Oracle NoSQL Database Cloud Service include the following dimensions:
  • RESOURCEID

    The OCID of the NoSQL Table in the Oracle NoSQL Database Cloud Service.

    Note:

    OCID is an Oracle-assigned unique ID that is included as part of the resource's information in both the console and API.

  • TABLENAME

    The name of the NoSQL table in the Oracle NoSQL Database Cloud Service.

Oracle NoSQL Database Cloud Service sends metrics to the Oracle Cloud Infrastructure Monitoring Service. You can view or create alarms on these metrics using the Oracle Cloud Infrastructure Console SDKs or CLI. See OCI SDKs and CLI in Oracle Cloud Infrastructure Documentation.

Available Metrics

Metric Metric Display Name Unit Description Dimensions
ReadUnits Read Units Units The number of read units consumed during this period. resourceIdtableName
WriteUnits Write Units Units The number of write units consumed during this period. resourceIdtableName
StorageGB Storage Size GB The maximum amount of storage consumed by the table. As this information is generated hourly, you may see values that are out of date in between the refresh points. resourceIdtableName
ReadThrottleCount Read Throttle Count The number of read throttling exceptions on this table in the time period. resourceIdtableName
WriteThrottleCount Write Throttle Count The number of write throttling exceptions on this table in the time period. resourceIdtableName
StorageThrottleCount Storage Throttle Count The number of storage throttling exceptions on this table in the time period. resourceIdtableName

Data Regions and Associated Service Endpoints

Learn about the data regions supported for Oracle NoSQL Database Cloud Service and access region-specific service endpoints.

Data Regions

To start with Oracle NoSQL Database Cloud Service, you must create an account (either for free trial or to purchase provisioning). Along with other details, the account application requires you to choose the default data region.

Service Endpoints Associated with Data Regions

A service endpoint is the regional network access point to the Oracle NoSQL Database Cloud Service. The general format of a region endpoint is https://nosql.{region}.oci.oraclecloud.com. For example, the service endpoint for the Ashburn Oracle NoSQL Database Cloud Service region identifier in North America region is https://nosql.us-ashburn-1.oci.oraclecloud.com. Different data regions have different {region} components of their URLs.

This table lists the service endpoints for all the data regions which are or will be supported by Oracle NoSQL Database Cloud Service. See Service Availability for the latest information about the regions that support Oracle NoSQL Database Cloud Service.

Data Region Region Identifier Service Endpoint
North America ca-montreal-1 https://nosql.ca-montreal-1.oci.oraclecloud.com
North America ca-toronto-1 https://nosql.ca-toronto-1.oci.oraclecloud.com
North America us-ashburn-1 https://nosql.us-ashburn-1.oci.oraclecloud.com
North America us-phoenix-1 https://nosql.us-phoenix-1.oci.oraclecloud.com
North America us-sanjose-1 https://nosql.us-sanjose-1.oci.oraclecloud.com
EMEA af-johannesburg-1 https://nosql.af-johannesburg-1.oci.oraclecloud.com
EMEA eu-amsterdam-1 https://nosql.eu-amsterdam-1.oci.oraclecloud.com
EMEA eu-frankfurt-1 https://nosql.eu-frankfurt-1.oci.oraclecloud.com
EMEA eu-madrid-1 https://nosql.eu-madrid-1.oci.oraclecloud.com
EMEA eu-marseille-1 https://nosql.eu-marseille-1.oci.oraclecloud.com
EMEA eu-milan-1 https://nosql.eu-milan-1.oci.oraclecloud.com
EMEA eu-paris-1 https://nosql.eu-paris-1.oci.oraclecloud.com
EMEA eu-stockholm-1 https://nosql.eu-stockholm-1.oci.oraclecloud.com
EMEA eu-zurich-1 https://nosql.eu-zurich-1.oci.oraclecloud.com
EMEA il-jerusalem-1 https://nosql.il-jerusalem-1.oci.oraclecloud.com
EMEA me-abudhabi-1 https://nosql.me-abudhabi-1.oci.oraclecloud.com
EMEA me-dubai-1 https://nosql.me-dubai-1.oci.oraclecloud.com
EMEA me-jeddah-1 https://nosql.me-jeddah-1.oci.oraclecloud.com
EMEA uk-cardiff-1 https://nosql.uk-cardiff-1.oci.oraclecloud.com
EMEA uk-london-1 https://nosql.uk-london-1.oci.oraclecloud.com
APAC ap-chuncheon-1 https://nosql.ap-chuncheon-1.oci.oraclecloud.com
APAC ap-hyderabad-1 https://nosql.ap-hyderabad-1.oci.oraclecloud.com
APAC ap-melbourne-1 https://nosql.ap-melbourne-1.oci.oraclecloud.com
APAC ap-mumbai-1 https://nosql.ap-mumbai-1.oci.oraclecloud.com
APAC ap-osaka-1 https://nosql.ap-osaka-1.oci.oraclecloud.com
APAC ap-seoul-1 https://nosql.ap-seoul-1.oci.oraclecloud.com
APAC ap-singapore-1 https://nosql.ap-singapore-1.oci.oraclecloud.com
APAC ap-sydney-1 https://nosql.ap-sydney-1.oci.oraclecloud.com
APAC ap-tokyo-1 https://nosql.ap-tokyo-1.oci.oraclecloud.com
LAD mx-queretaro-1 https://nosql.mx-queretaro-1.oci.oraclecloud.com
LAD sa-santiago-1 https://nosql.sa-santiago-1.oci.oraclecloud.com
LAD sa-saopaulo-1 https://nosql.sa-saopaulo-1.oci.oraclecloud.com
LAD sa-vinhedo-1 https://nosql.sa-vinhedo-1.oci.oraclecloud.com