Note
This view is available starting with V4.2.0.
Purpose
This view displays the GTS/STS values of the GTS service for the tenant.
The values vary based on the database:
- For a primary database, it displays the current GTS value allocated to the primary database.
- For a standby database, it displays the current readable point (STS) value of the standby database.
The values vary based on the tenant:
- In the sys tenant, you can view the clocks of all tenants.
- In a user tenant, you can view only the clocks of the current tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID.
|
| TS_TYPE | VARCHAR2(100) | NO | The type of the clock source.
|
| TS_VALUE | NUMBER(38) | NO | The current clock value stored in memory. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the node where the clock service resides. |
| SVR_PORT | NUMBER(38) | NO | The port number of the node where the clock service resides. |
Sample query
In a user tenant, query the GTS/STS values, the node information where the clock service resides, and the clock source type of the current tenant.
obclient [SYS]> SELECT * FROM SYS.V$OB_TIMESTAMP_SERVICE;
The query result is as follows:
+-----------+---------+---------------------+----------------+----------+
| TENANT_ID | TS_TYPE | TS_VALUE | SVR_IP | SVR_PORT |
+-----------+---------+---------------------+----------------+----------+
| 1004 | GTS | 1742974578234478001 | 11.xxx.xxx.xxx | 28825 |
+-----------+---------+---------------------+----------------+----------+
1 row in set