Oracle | DBMS_TELEMETRY

Oracle DBMS_TELEMETRY_QUERY Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Provides functions to query metrics from Oracle AI Database Telemetry Streaming.

AUTHID DEFINER

Dependencies

DBMS_TELEMETRY_QUERY_INTERNAL

Documented Yes

First Available 26ai

Security Model Owned by TELEMETRY_DBA with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvthtelemetry_int.plb
{ORACLE_HOME}/rdbms/admin/prvtbtelemetry_int.plb

Do not install by running the above scripts. Install with telemetry_install_plsql.sql running with oracle_script enabled.

Subprograms

PROMQL_INSTANT	PROMQL_RANGE	PROMQL_SERIES
PROMQL_LABEL

PROMQL_INSTANT (new 26ai)

Returns a CLOB for queries based on a time range dbms_telemetry_query.promql_instant( promoql_query IN VARCHAR2, instant_time_epoch IN NUMBER, fetch_sql IN NUMBER DEFAULT 0) RETURN CLOB;

TBD

PROMQL_LABEL (new 26ai)

Fetches all the distinct values that a key can take dbms_telemetry_query.promql_label( promoql_query IN VARCHAR2, start_time_epoch IN NUMBER, end_time_epoch IN NUMBER, fetch_sql IN NUMBER DEFAULT 0); RETURN CLOB;

TBD

PROMQL_RANGE (new 26ai)

Returns time series for a particular timestamp dbms_telemetry_query.promql_range( promoql_query IN VARCHAR2, start_time_epoch IN NUMBER, end_time_epoch IN NUMBER, step_size_seconds IN NUMBER DEFAULT 10, fetch_sql IN NUMBER DEFAULT 0) RETURN CLOB;

TBD

PROMQL_SERIES (new 26ai)

Fetches time series metadata (metric name and tags) dbms_telemetry_query.promql_series( promoql_query IN VARCHAR2, start_time_epoch IN NUMBER, end_time_epoch IN NUMBER, fetch_sql IN NUMBER DEFAULT 0) RETURN CLOB;

TBD