Using console to list tables and view table information

Learn how to use OCI console to list Oracle NoSQL Database Cloud Service tables and view the table information.

This article has the following topics:

Related Topics

Viewing Tables

You can view Oracle NoSQL Database Cloud Service tables from the NoSQL console.

To view tables:
  1. Access the NoSQL console from the Infrastructure Console. See Accessing the Service from the Infrastructure Console .
  2. You can view all the tables in your tenancy from the NoSQL console.

Viewing Table Details

Learn how to view Oracle NoSQL Database Cloud Service table details from the NoSQL console.

To view table details:
  1. Access the NoSQL console from the Infrastructure Console. See Accessing the Service from the Infrastructure Console .
  2. The NoSQL console lists all the tables in the tenancy.
  3. A column in the list (Child tables) shows how many child tables are owned by the specified table.
  4. The list of child tables for a given parent table can be viewed by clicking the Child tables link under Resources on the parent table's details page.
  5. A column in the list (Schema state) takes in one of the two values, Mutable and Frozen. The schema for a table with no replication is mutable and for a Global Active table schema is frozen (schema cannot be changed).
  6. A column in the list (Global active) indicates if it is a singleton table (no replication) or a Global Active table.
  7. The NoSQL console lists all the tables in the tenancy. To view table details, do either of the following:
    • Click the table name, or
    • Click the action menu corresponding to the table name and select View Details.
    The Table Details page opens up.
  8. From the Table Details page, you can view all table columns, indexes, rows, and metrics. The field Local replica initialization completeness is shown only if the table is a Global Active table.
    Description of singletab_set.png follows
    Description of the illustration singletab_set.png

Viewing Table DDL

Learn how to view Oracle NoSQL Database Cloud Service table DDL from the NoSQL console.

To view table DDL:
  1. Access the NoSQL console from the Infrastructure Console. See Accessing the Service from the Infrastructure Console .
  2. The NoSQL console lists all the tables in the tenancy.
  3. In the Table Details page, click View Table DDL.
    The View Table DDL window displays the table DDL statement.
  4. Now, you can select and copy the table DDL statement from the window. Click OK to close the window.

Viewing Table Columns

Learn how to view Oracle NoSQL Database Cloud Service table metrics from the NoSQL console.

To view table columns:
  1. Access the NoSQL console from the Infrastructure Console. See Accessing the Service from the Infrastructure Console
  2. The NoSQL console lists all the tables in the compartment.
  3. In the Table Details page, select the Columns under Resources.
    • You can view the Column name with its corresponding Type.
    • You can also view whether the column can be NULL or not.
    • It also displays whether a column is assigned as Primary key or Shard key with "Yes" or "No".

      Note:

      Columns assigned as Shard key are also Primary key. To understand more about Primary and Shard key, see Primary Keys and Shard Keys
To add new columns to the table, see Altering Singleton Tables.

Viewing Table Metrics

Learn how to view Oracle NoSQL Database Cloud Service table metrics from the NoSQL console.

To view table metrics:
  1. Access the NoSQL console from the Infrastructure Console. See Accessing the Service from the Infrastructure Console .
  2. The NoSQL console lists all the tables in the tenancy.
  3. In the Table Details page, select the Metrics tab under Resources.
    Table metrics such as Read Units, Write Units, Storage GB, Read Throttle Count, Write Throttle Count, Storage Throttle Count, Maximum shard usage percent, and Replica lag show up. You can filter the metrics by date, change interval, and statistic value.
  4. For each of the metrics displayed on this page, you can perform the following actions:
    • View Query in Metrics Explorer: This page lets you write and edit queries in Monitoring Query Language (MQL), using metrics from either your application or an Oracle Cloud Infrastructure service. If you're not familiar with MQL, see Monitoring Query Language (MQL) Reference. To learn more about this page, see Metrics Explorer.
    • Copy Chart URL: Click this option to copy the default metrics chart URL for any future reference.
    • Copy Query (MQL): Click this option to copy the MQL query used to create the default metrics chart. If you're not familiar with MQL, see Monitoring Query Language (MQL) Reference.
    • Create an Alarm on this Query: Click this option to create alarms to monitor your cloud resources. To learn about alarms, see Managing Alarms.
    • Table view: Click this option to view the metrics in a table format. The metrics is displayed as a table with Time Stamp and Value columns. To toggle back to chart format, select the Chart view option.