Oracle DBMS_TELEMETRY_ADMIN_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 CURRENT_USER
Dependencies
ALL_PART_TABLES DBMS_TELEMETRY_INGEST
ALL_TABLES DBMS_TELEMETRY_JOBS
ALL_TAB_PARTITIONS DBMS_TELEMETRY_QUERY_INTERNAL
ALL_TAB_SUBPARTITIONS DBMS_TELEMETRY_UTILS
DBMS_ASSERT DBMS_TELEMETRY_UTILS_INTERNAL
DBMS_OUTPUT DUAL
DBMS_SESSION TS_TABLE
DBMS_TELEMETRY_ADMIN USER_TABLES
DBMS_TELEMETRY_DBA_INTERNAL  
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_USER (new 26ai)
Undocumented dbms_telemetry_admin_internal.add_user(
workspace_name IN VARCHAR2,
user_name      IN VARCHAR2,
user_role      IN VARCHAR2);
TBD
 
CREATE_NEXT_HOUR_TABLE (new 26ai)
Undocumented dbms_telemetry_admin_internal.create_next_hour_table(workspace_name IN VARCHAR2);
TBD
 
CREATE_NEXT_PARTITION (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_next_partition(workspace_name IN VARCHAR2);
TBD
 
DATA_MANAGE_COMPRESS_UTIL (new 26ai)
Undocumented dbms_telemetry_admin_internal.data_manage_compress_util(workspace_name IN VARCHAR2);
TBD
 
DATA_MANAGE_DOWNSAMPLE_UTIL (new 26ai)
Undocumented dbms_telemetry_admin_internal.data_manage_downsample_util(workspace_name IN VARCHAR2);
TBD
 
DATA_MANAGE_DROP_UTIL (new 26ai)
Undocumented dbms_telemetry_admin_internal.data_manage_drop_util(workspace_name IN VARCHAR2);
TBD
 
DROP_TABLE (new 26ai)
Undocumented dbms_telemetry_admin_internal.drop_table(
workspace_name IN VARCHAR2,
tm             IN TIMESTAMP WITH TIME ZONE);
TBD
 
DROP_TABLES (new 26ai)
Undocumented dbms_telemetry_admin_internal.drop_tables(
workspace_name IN VARCHAR2,
tm             IN TIMESTAMP WITH TIME ZONE,
hours          IN NUMBER);
TBD
 
GET_CURSCHEMA_TS_TABLE_IDX (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_curschema_ts_table_idx(
tm        IN TIMESTAMP,
ts_schema IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GET_DATA_TABLE_NAME (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_data_table_name(
tm             IN TIMESTAMP WITH TIME ZONE,
workspace_name IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GET_DHDATA_TABLE_NAME (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_dhdata_table_name(tm IN TIMESTAMP) RETURN VARCHAR2;
TBD
 
GET_DHTABLE_SUFFIX_NAME (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_dhtable_suffix_name(tm IN TIMESTAMP) RETURN VARCHAR2;
TBD
 
GET_DHTS_TABLE_NAME (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_dhts_table_name(tm IN TIMESTAMP) RETURN VARCHAR2;
TBD
 
GET_MHDATA_TABLE_NAME (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_mhdata_table_name(tm IN TIMESTAMP) RETURN VARCHAR2;
TBD
 
GET_MHTS_SUFFIX_NAME (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_mhts_suffix_name(tm IN TIMESTAMP) RETURN VARCHAR2;
TBD
 
GET_MHTS_TABLE_NAME (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_mhts_table_name(tm IN TIMESTAMP) RETURN VARCHAR2;
TBD
 
GET_PARAMETER (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_parameter
workspace_name IN VARCHAR2,
pname          IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GET_SHDATA_TABLE_NAME (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_shdata_table_name(tm IN TIMESTAMP) RETURN VARCHAR2;
TBD
 
GET_SHTABLE_SUFFIX_NAME (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_shtable_suffix_name(tm IN TIMESTAMP) RETURN VARCHAR2;
TBD
 
GET_SHTS_TABLE_NAME (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_shts_table_name(tm IN TIMESTAMP) RETURN VARCHAR2;
TBD
 
GET_TABLE_SUFFIX_NAME (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_table_suffix_name(tm IN TIMESTAMP WITH TIME ZONE)
RETURN VARCHAR2;
TBD
 
GET_TS_TABLE_IDX (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_ts_table_idx(
tm             IN TIMESTAMP WITH TIME ZONE,
workspace_name IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GET_TS_TABLE_NAME (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_ts_table_name(
tm             IN TIMESTAMP WITH TIME ZONE,
workspace_name IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GET_USER (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_user RETURN VARCHAR2;
TBD
 
GET_WHDATA_TABLE_NAME (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_whdata_table_name(tm IN TIMESTAMP) RETURN VARCHAR2;
TBD
 
GET_WHTABLE_SUFFIX_NAME (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_whtable_suffix_name(tm IN TIMESTAMP) RETURN VARCHAR2;
TBD
 
GET_WHTS_TABLE_NAME (new 26ai)
Undocumented dbms_telemetry_admin_internal.get_whts_table_name(tm IN TIMESTAMP) RETURN VARCHAR2;
TBD
 
REMOVE_USER (new 26ai)
Undocumented dbms_telemetry_admin_internal.remove_user(
workspace_name IN VARCHAR2,
user_name      IN VARCHAR2);
TBD
 
SET_PARAMETER (new 26ai)
Undocumented dbms_telemetry_admin_internal.set_parameter
workspace_name IN VARCHAR2,
pname          IN VARCHAR2,
pvalue         IN VARCHAR2);
TBD
 
SET_USER (new 26ai)
Undocumented dbms_telemetry_admin_internal.set_user(user_name IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_TELEMETRY_ADMIN
DBMS_TELEMETRY_DBA_INTERNAL
DBMS_TELEMETRY_INGEST
DBMS_TELEMETRY_JOBS
DBMS_TELEMETRY_QUERY_INTERNAL
DBMS_TELEMETRY_UTILS
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