Oracle | DBMS_TELEMETRY_DBA

Oracle DBMS_TELEMETRY_DBA_INTERNAL 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 Undocumented

AUTHID DEFINER

Dependencies

ALL_TABLES	DBMS_TELEMETRY_UTILS
ALL_TAB_PARTITIONS	DBMS_TELEMETRY_UTILS_INTERNAL
ALL_USERS	DBMS_TELEMETRY_WORKSPACE
DBMS_ASSERT	DBMS_UTILITY
DBMS_LOB	JSON_ARRAY_T
DBMS_OUTPUT	JSON_ELEMENT_T
DBMS_STANDARD	JSON_OBJECT_T
DBMS_TELEMETRY	ODCIVARCHAR2LIST
DBMS_TELEMETRY_ADMIN	PLITBLM
DBMS_TELEMETRY_ADMIN_INTERNAL	PRODUCT_COMPONENT_VERSION
DBMS_TELEMETRY_INGEST	TELEMETRY_ADMINS
DBMS_TELEMETRY_JOBS	TELEMETRY_USERS
DBMS_TELEMETRY_QUERY_INTERNAL	TELEMETRY_WORKSPACES
DBMS_TELEMETRY_SYS	USER_OBJECTS

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

ADD_ADMIN	GET_PARTITION_INTERVAL	LOG_QUERY
ADD_USER	GET_USER_ID	PARTITION_MANAGE
ALTER_SEGMENT	GET_WORKSPACE	PROMQL_LABEL
CREATE_SINGLE_TABLE	GET_WORKSPACE_ID	PROMQL_POINT
CREATE_TABLE	GET_WORKSPACE_NAME	PROMQL_RANGE
CREATE_TABLE_EPOCH	GET_WORKSPACE_SCHEMA	PROMQL_SERIES
CREATE_WORKSPACE	INGESTNF1_DBA	RECORD_REJECTS
DBVERSION	INGESTNF_DBA	REMOVE_ADMIN
DEQUOTE	INITIALIZE_ORDS	REMOVE_USER
DROP_WORKSPACE	INIT_PARAMETERS_DBA	SET_PARAMETER
ERR	IS_ADMIN	VALIDATE_PARAMETER_NAME
GET_BOUND_VALUE	IS_WORKSPACE_USER	VALIDATE_PARAMETER_VALUE
GET_DEFAULT	LOG	VALIDATE_SET_PARAMETER
GET_ORDS_ADMIN	LOG_ERROR	VALIDATE_SQLNAME
GET_PARAMETER	LOG_INGEST	VALIDATE_USER

ADD_ADMIN (new 26ai)

Undocumented dbms_telemetry_dba_internal.add_admin( workspace_name IN VARCHAR2, admin_user IN VARCHAR2);

TBD

ADD_USER (new 26ai)

Undocumented dbms_telemetry_dba_internal.add_user( workspace_name IN VARCHAR2, admin_name IN VARCHAR2, user_name IN VARCHAR2, user_role IN VARCHAR2);

TBD

ALTER_SEGMENT (new 26ai)

Undocumented dbms_telemetry_dba_internal.alter_segment( segment_creation IN VARCHAR2, workspace_name IN VARCHAR2);

TBD

CREATE_SINGLE_TABLE (new 26ai)

Undocumented dbms_telemetry_dba_internal.create_single_table(workspace_name IN VARCHAR2);

TBD

CREATE_TABLE (new 26ai)

Undocumented dbms_telemetry_dba_internal.create_table( ts IN TIMESTAMP, curr_user IN VARCHAR2, workspace_name IN VARCHAR2, start_user_time IN NUMBER);

TBD

CREATE_TABLE_EPOCH (new 26ai)

Undocumented dbms_telemetry_dba_internal.create_table_epoch( for_epoch IN NUMBER, curr_user IN VARCHAR2, workspace_name IN VARCHAR2);

TBD

CREATE_WORKSPACE (new 26ai)

Undocumented dbms_telemetry_dba_internal.create_workspace( workspace_name IN VARCHAR2, tablespace_name IN VARCHAR2);

TBD

DBVERSION (new 26ai)

Undocumented dbms_telemetry_dba_internal.dbversion RETURN NUMBER;

TBD

DEQUOTE (new 26ai)

Undocumented dbms_telemetry_dba_internal.dequote.v IN VARCHAR2) RETURN VARCHAR2;

TBD

DROP_WORKSPACE (new 26ai)

Undocumented dbms_telemetry_dba_internal.drop_workspace( workspace_name IN VARCHAR2, force IN NUMBER);

TBD

ERR (new 26ai)

Undocumented dbms_telemetry_dba_internal.err( error_num IN NUMBER, arg1 IN VARCHAR2, arg3 IN VARCHAR2);

TBD

GET_BOUND_VALUE (new 26ai)

Undocumented dbms_telemetry_dba_internal.get_bound_value( workspace_name IN VARCHAR2, tm IN NUMBER) RETURN NUMBER;

TBD

GET_DEFAULT (new 26ai)

Undocumented dbms_telemetry_dba_internal.get_default(pname IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_ORDS_ADMIN (new 26ai)

Undocumented dbms_telemetry_dba_internal.get_ords_admin( workspace_name IN VARCHAR2, client_id OUT VARCHAR2, client_secret OUT VARCHAR2);

TBD

GET_PARAMETER (new 26ai)

Undocumented dbms_telemetry_dba_internal.get_parameter( workspace_name IN VARCHAR2, pname IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_PARTITION_INTERVAL (new 26ai)

Undocumented dbms_telemetry_dba_internal.getpartition_interval( interval_str IN VARCHAR2, current_epoch IN NUMBER) RETURN NUMBER;

TBD

GET_USER_ID (new 26ai)

Undocumented dbms_telemetry_dba_internal.get_user_id(user_name IN VARCHAR2) RETURN NUMBER;

TBD

GET_WORKSPACE (new 26ai)

Undocumented dbms_telemetry_dba_internal.get_workspace( user_name IN VARCHAR2, workspace_name_canon OUT VARCHAR2, workspace_id OUT NUMBER);

TBD

GET_WORKSPACE_ID (new 26ai)

Undocumented dbms_telemetry_dba_internal.get_workspace_id(workspace_name IN VARCHAR2) RETURN NUMBER;

TBD

GET_WORKSPACE_NAME (new 26ai)

Undocumented dbms_telemetry_dba_internal.get_workspace_name(workspace_schema IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_WORKSPACE_SCHEMA (new 26ai)

Undocumented dbms_telemetry_dba_internal.get_workspace_schema(workspace_name IN VARCHAR2) RETURN VARCHAR2;

TBD

INGESTNF1_DBA (new 26ai)

Undocumented dbms_telemetry_dba_internal.ingestnf1_db( p_data IN CLOB, p_status OUT NUMBER, ingest_user IN VARCHAR2, ing_time IN NUMBER, workspace_name_canon IN VARCHAR2) RETURN JSON_OBJECT_T;

TBD

INGESTNF_DBA (new 26ai)

Undocumented dbms_telemetry_dba_internal.ingestnf_dba( p_data IN CLOB, p_status OUT NUMBER, ingest_user IN VARCHAR2, ing_time IN NUMBER, workspace_name_canon IN VARCHAR2) RETURN JSON_OBJECT_T;

TBD

INITIALIZE_ORDS (new 26ai)

Undocumented dbms_telemetry_dba_internal.initialize_ords(workspace_name IN VARCHAR2);

TBD

INIT_PARAMETERS_DBA (new 26ai)

Undocumented dbms_telemetry_dba_internal.init_parameters_db(workspace_name IN VARCHAR2);

TBD

IS_ADMIN (new 26ai)

Undocumented dbms_telemetry_dba_internal.is_admin( workspace_name IN VARCHAR2, admin_user IN VARCHAR2) RETURN BOOLEAN;

TBD

IS_WORKSPACE_USER (new 26ai)

Undocumented dbms_telemetry_dba_internal.is_workspace_user( workspace_name IN VARCHAR2, user_name IN VARCHAR2) RETURN BOOLEAN;

TBD

LOG (new 26ai)

Undocumented dbms_telemetry_dba_internal.log( mesg IN VARCHAR2, workspace_name IN VARCHAR2);

TBD

LOG_ERROR (new 26ai)

Undocumented dbms_telemetry_dba_internal.log_error( curr_user IN VARCHAR2, message IN CLOB, workspace_name_canon IN VARCHAR2);

TBD

LOG_INGEST (new 26ai)

Undocumented dbms_telemetry_dba_internal.log_ingest( curr_user IN VARCHAR2, result IN VARCHAR2, workspace_name_canon IN VARCHAR2);

TBD

LOG_QUERY (new 26ai)

Undocumented dbms_telemetry_dba_internal.log_query( curr_user IN VARCHAR2, result IN VARCHAR2);

TBD

PARTITION_MANAGE (new 26ai)

Undocumented dbms_telemetry_dba_internal.partition_manage( data_table_name IN VARCHAR2, ts_table_name IN VARCHAR2, workspace_name IN VARCHAR2);

TBD

PROMQL_LABEL (new 26ai)

Undocumented dbms_telemetry_dba_internal.promql_label( promql_query IN VARCHAR2, start_time IN NUMBER, end_time IN NUMBER, bound_start_time IN NUMBER, bound_end_time IN NUMBER, user_id IN NUMBER, ts_schema IN VARCHAR2, result_type IN NUMBER) RETURN CLOB;

TBD

PROMQL_POINT (new 26ai)

Undocumented dbms_telemetry_dba_internal.promql_point( promql_query IN VARCHAR2, point-time IN NUMBER, bound_start_time IN NUMBER, bound_end_time IN NUMBER, user_id IN NUMBER, ts_schema IN VARCHAR2, result_type IN NUMBER) RETURN CLOB;

TBD

PROMQL_RANGE (new 26ai)

Undocumented dbms_telemetry_dba_internal.promql_range( promql_query IN VARCHAR2, start_time IN NUMBER, end_time IN NUMBER, step_size IN NUMBER, bound_start_time IN NUMBER, bound_end_time IN NUMBER, user_id IN NUMBER, ts_schema IN VARCHAR2, result_type IN NUMBER) RETURN CLOB;

TBD

PROMQL_SERIES (new 26ai)

Undocumented dbms_telemetry_dba_internal.promql_series( promql_query IN VARCHAR2, start_time IN NUMBER, end_time IN NUMBER, bound_start_time IN NUMBER, bound-end_time IN NUMBER, user_id IN NUMBER, ts_schema IN VARCHAR2, result_type IN NUMBER) RETURN CLOB;

TBD

RECORD_REJECTS (new 26ai)

Undocumented dbms_telemetry_dba_internal.record_rejects( begin_time IN NUMBER, end_time IN NUMBER, ing_time IN NUMBER, workspace_name IN VARCHAR2)RETURN CLOB;

TBD

REMOVE_ADMIN (new 26ai)

Undocumented dbms_telemetry_dba_internal.remove_admin( workspace_name IN VARCHAR2, admin_user IN VARCHAR2);

TBD

REMOVE_USER (new 26ai)

Undocumented dbms_telemetry_dba_intenternal.remove_user( workspace_name IN VARCHAR2, admin_name IN VARCHAR2, user_name IN VARCHAR2);

TBD

SET_PARAMETER (new 26ai)

Undocumented dbms_telemetry_dba_internal.set_parameter( workspace_name IN VARCHAR2, pname IN VARCHAR2, pvalue iN VARCHAR2);

TBD

VALIDATE_PARAMETER_NAME (new 26ai)

Undocumented dbms_telemetry_dba_internal.validate_parameter_name(pname IN VARCHAR2) RETURN VARCHAR2;

TBD

VALIDATE_PARAMETER_VALUE (new 26ai)

Undocumented dbms_telemetry_dba_internal.validate_parameter_value(pvalue IN VARCHAR2) RETURN VARCHAR2;

TBD

VALIDATE_SET_PARAMETER (new 26ai)

Undocumented dbms_telemetry_dba_internal.validate_set_parameter( pname IN VARCHAR2, pvalue IN VARCHAR2);

TBD

VALIDATE_SQLNAME (new 26ai)

Undocumented dbms_telemetry_dba_internal.validate_sqlname( sql_name IN VARCHAR2, workspace IN BOOLEAN) RETURN VARCHAR2;

TBD

VALIDATE_USER (new 26ai)

Undocumented dbms_telemetry_dba_internal.validate_user(user_name IN VARCHAR2) RETURN VARCHAR2;

TBD