Oracle DBMS_TELEMETRY_UTILS
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 AI telemetry streaming utilities
AUTHID DEFINER
Dependencies
DBMS_TELEMETRY_ADMIN_INTERNAL DBMS_TELEMETRY_UTILS_INTERNAL
DBMS_TELEMETRY_DBA_INTERNAL TS_TABLE
Documented No
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
 
GET_EPOCH_SECONDS (new 26ai)
Undocumented dbms_telemetry_utils.get_epoch_seconds(RETURN NUMBER);
conn sys as sysdba
Password:

SELECT telemetry_dba.dbms_telemetry_utils.get_epoch_seconds;

ORA-06598: insufficient INHERIT PRIVILEGES privilege
 
ROUND_OFF_TIME (new 26ai)
Undocumented dbms_telemetry_utils.round_off_time(
start_time_epoch   IN NUMBER,
current_time_epoch IN NUMBER,
step_size_seconds  IN NUMBER DEFAULT 10)
RETURN NUMBER;
TBD
 
TO_EPOCH (new 26ai)
Undocumented dbms_telemetry_utils.to_epoch(ts IN TIMESTAMP WITH TIME ZONE) RETURN NUMBER;
TBD
 
TO_TS (new 26ai)
Undocumented dbms_telemetry_utils.to_ts(epoch_secs IN NUMBER) RETURN TIMESTAMP WITH TIME ZONE;
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_TELEMETRY_ADMIN_INTERNAL
DBMS_TELEMETRY_DBA_INTERNAL
DBMS_TELEMETRY_UTILS_INTERNAL
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved