14 Sharded Databases
This chapter provides information about the Sharded Database metrics.
Sharding is a data tier architecture in which data is horizontally partitioned across independent databases. Each database is hosted on a dedicated server with its own local resources - CPU, memory, flash, or disk, and each database in such a configuration is called a shard. All the shards together make up a single logical database, which is referred to as a sharded database (SDB).
Global Service Manager
This chapter provides information about the metric categories available for the Global Service Manager target.
In support of Oracle Sharding, Global Service Managers support routing of connections based on data location. A global service manager, in the context of Oracle Sharding, is known as a shard director.
Global Service Performance
This section provides information on the metrics in the Global Service Performance category.
| Target Version | Evaluation and Collection Frequency |
|---|---|
| 12c and later | Every 5 minutes |
| Metric Name | Description | Unit |
|---|---|---|
| Average Response Time | Elapsed time per user call. | Milliseconds |
| CPU IO Violations | Count of CPU IO threshold violations. | None |
| CPU Load | CPU utilization | Percentage |
| Calls Per Second | Number of logins, parses, or execute calls per second during the sample period. | None |
| Collected Region | Name of the GSM region. | None |
| Latency | Network latency between database region and GSM region. | Milliseconds |
| Latency Region | Name of the GSM region for which latency is computed. | None |
| Master | Global Master GSM | None |
| Region Master | Regional Master GSM | None |
| Runtime Load Balance | Percentage of workload for runtime load balancing purposes. | None |
| Session Count | Current session count over the past 30 seconds. | None |
Load
This section provides information on the metrics in the Load category.
| Target Version | Evaluation and Collection Frequency |
|---|---|
| 12c and later | Every 5 minutes |
| Metric Name | Description | Unit |
|---|---|---|
| Connections Established (per min) | Count of connections established per minute. | None |
| Connections Refused (per min) | Count of connections refused per minute. | None |
General Status
This section provides information on the metrics in the General Status category.
| Target Version | Evaluation and Collection Frequency |
|---|---|
| 12c and later | Every 5 minutes |
| Metric Name | Description | Unit |
|---|---|---|
| Host | GSM host | None |
| Port | GSM port | None |
| Region | Region name | None |
| Region Master | Regional master GSM | None |
| Start Date | GSM start time | Date |
| TNSPING Response Time | Response time of TNSPING test from GDS home to GSM server. | Milliseconds |
| TNSPING Status | Status of TNSPING test from GDS home to GSM server. | Status (0 or 1) |