About the Service

This section provides an overview of Oracle NoSQL Database Cloud Service.

Oracle NoSQL Database Cloud Service is a fully managed database cloud service that is designed for database operations that require predictable, single digit millisecond latency responses to simple queries. NoSQL Database Cloud Service allows developers to focus on application development rather than setting up cluster servers, or performing system monitoring, tuning, diagnosing, and scaling. NoSQL Database Cloud Service is suitable for applications such as Internet of Things, user experience personalization, instant fraud detection, and online display advertising.

Once you are authenticated against your Oracle Cloud account, you can create a NoSQL table, and specify throughput and storage requirements for the table. Oracle reserves and manages the resources to meet your requirements, and provisions capacity for you. Capacity is specified using read and write units for throughput and GB for storage units. See Estimating Capacity.

Service Access Options

As a developer, you can connect to the Oracle NoSQL Database Cloud Service and work with NoSQL tables using the NoSQL SDKs available in multiple languages. To learn how to download and use the NoSQL SDKs, see Developing in Oracle Cloud.

In addition to the NoSQL SDKs, Oracle NoSQL Database Cloud Service also provides Oracle Cloud Infrastructure Console for you to access, manage, and use the NoSQL Database Cloud Service. The Oracle Cloud Infrastructure Console lets you create and manage NoSQL tables and indexes declaratively. You can also manipulate the data in your NoSQL tables and monitor your Oracle NoSQL Database Cloud Service from the console. See Using the Console to Manage Tables.

Region Availability

For the latest information on the regions where Oracle NoSQL Database Cloud Service is available, see Data Regions for Platform and Infrastructure Services.

Tip:

To find the service endpoint for a specific data region, see Data Regions and Associated Service Endpoints.

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.

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.

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.

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.

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.

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

Before You Begin

When you order Oracle NoSQL Database Cloud Service through Universal Credits, you automatically get access to other required services, including Oracle Cloud Infrastructure.

Here's some information about how Oracle NoSQL Database Cloud Service uses other services and what you need to do if you're setting up Oracle NoSQL Database Cloud Service for the first time.

Service What is it for? Do I need to do anything?
Oracle Cloud Infrastructure Identity and Access Management
  • You use Oracle Cloud Infrastructure Identity and Access Management to create user accounts for the people in your organization who will use Oracle NoSQL Database Cloud Service.
  • You can give users permission to inspect, read, use, or manage Oracle NoSQL Database Cloud Service tables. See Setting Up Users, Groups, and Policies
  • You use compartments within your tenancy to organize tables on Oracle Cloud Infrastructure.
Yes.

Before you create your first Oracle NoSQL Database Cloud Service table, Oracle recommends that you set up one or more compartments in which you deploy and secure your table.

Typical Workflow

Typical sequence of tasks to work with Oracle NoSQL Database Cloud Service.

If you're developing applications using Oracle NoSQL Database Cloud Service for the first time, follow these tasks as a guide.

Task Description More Information
Connect your application Connect your application to use Oracle NoSQL Database Cloud Service tables. Connecting your Application
Develop your application Develop your application after connecting to Oracle NoSQL Database Cloud Service tables. Developing in Oracle Cloud

Developing in Oracle NoSQL Database Cloud Simulator

If you're setting up Oracle NoSQL Database Cloud Service for the first time, see Setting up Your Service.