A.1 Tables and Views

The following tables and views are used in Telemetry Streaming.

Oracle DBA Views

The following views are accessible to users having the Oracle DBA role.

Table -1 TELEMETRY_DBA.TELEMETRY_WORKSPACES

Columns Data Type Description

WORKSPACE_ID

NUMBER

Workspace ID

WORKSPACE_NAME

VARCHAR2(128)

Name of the workspace

TABLESPACE_NAME

VARCHAR2(128)

Default tablespace of the workspace

CREATION_TIME

DATE

Time at which this workspace was created

Table -2 TELEMETRY_DBA.TELEMETRY_ADMINS

Columns Data Type Description

WORKSPACE_ID

NUMBER

Workspace ID

ADMIN_USER

VARCHAR2(128)

The database user who is assigned as an ADMIN to the workspace ID

ADMIN_USERID

NUMBER

User ID of the ADMIN_USER

CREATION_TIME

DATE

Time at which the user was assigned as an admin user

Admin User Views

The following views are accessible to users with the workspace administrator role.

Table -3 TELEMETRY_DBA.TELEMETRY_WORKSPACE_USERS

Column Data Type Description

WORKSPACE_ID

NUMBER

This is an automatically generated unique ID for every workspace created

WORKSPACE_NAME

VARCHAR2(128)

Name of the workspace given at the time of creation

USER_NAME

VARCHAR2(128)

The database user name of the user associated with this workspace

USER_ROLE

VARCHAR2(128)

'INGEST', 'QUERY' or 'INGEST|QUERY' are the valid values

Table -4 TM$<workspace name>.TELEMETRY_INGEST_STATS

Column Data Type Description

PAYLOAD_SIZE

NUMBER

The size of the ingest payload in bytes

METRICS_INGESTED

NUMBER

Number of metrics ingested

METRICS_DISCARDED

NUMBER

Number of metrics rejected

INGEST_USERNAME

VARCHAR2(128)

Username of the ingest user

INGEST_DURATION_MILLISECONDS

NUMBER

Time taken for ingest in ms
INGEST_METHOD

VARCHAR2(200)

(PLSQL or REST)
INGEST_TIMESTAMP

TIMESTAMP(6)

The time of ingestion

Table -5 TM$<workspace name>.TELEMETRY_INGEST_DISCARDS

Column Data Type Description

METRIC_NAME

VARCHAR2(512)

The metric name

METRIC_TAGS

VARCHAR2(4000)

The metric tags

METRIC_VALUE

NUMBER

The metric value

METRIC_TIME_EPOCH

NUMBER

Time in epoch

INGEST_PAYLOAD_ARRIVAL_TIME

NUMBER

Epoch of ingest payload receive
DISCARD_REASON

VARCHAR2(500)

Why was the ingest discarded?
DISCARD_TIMESTAMP

TIMESTAMP(6)

The time at which the ingest was discarded

Table -6 TM$<workspace name>.TELEMETRY_QUERY_STATS

Column Data Type Description

QUERY_TYPE

VARCHAR2(200)

(Instant, Range, Label, or Series)

START_TIME_EPOCH

NUMBER

The query start time in epoch

END_TIME_EPOCH

NUMBER

The query end time in epoch

STEP_SIZE_SECONDS

NUMBER

The Step Size for range queries

QUERY_USERNAME

VARCHAR2(128)

The username of the query user
QUERY_DURATION_MILLISECONDS

NUMBER

The time taken for the ingest in ms
QUERY_METHOD

VARCHAR2(200)

(PLSQL or REST)
QUERY_TIMESTAMP

TIMESTAMP(6)

The time of the query

Table -7 TM$<workspace name>.TELEMETRY_ADMIN_LOG

Column Data Type Description

LOG_MESSAGE

VARCHAR2(4000)

Message Text

LOG_TIMESTAMP

TIMESTAMP(6)

Th timestamp of the message

Note:

Query stats are gathered and inserted into stats table through an autonomous transaction as a part of the query. As a result, there is a write operation into the database as a part of the query. This prevents PromQL queries to be executed from Read-only, standby databases.

Query User Views

The following views are accessible to users with the query user role.

Table -8 TM$<workspace name>.TELEMETRY_METRICS

Column Data Type Description

METRIC_NAME

VARCHAR2(512)

The metric name part of the time series

METRIC_TAGS

VARCHAR2(4000)

The tags part of the time series in JSON format

METRIC_VALUE

NUMBER

The point-in-time value of the time series

METRIC_TIME_EPOCH

NUMBER

The time in epoch