WL#13439: Sys Schema, Replace Stored Functions With Native Functions
Affects: Server-8.0
—
Status: Complete
WL#7803 "Performance Schema, Native Functions" introduces four native functions to format or retrieve data from the Performance Schema:
format_pico_time()- Format picosecond timeformat_bytes()- Format a number of bytesPS_current_thread_id()- Get the Performance Schema thread id for the current threadPS_thread_id()- Get the Performance Schema thread id for another thread
Views and stored procedures in the Sys Schema now call these native functions instead of the corresponding stored functions, specifically:
- Calls to
sys.format_bytes()are replaced withformat_bytes() - Calls to
sys.format_time()are replaced withformat_pico_time() - Calls to
sys.ps_thread_id(NULL)are replaced withps_current_thread_id() - Calls to
sys.ps_thread_id(connection_id)are replaced withps_thread_id(connection_id).
The original Sys Schema functions, sys.format_bytes(), sys.format_time() and sys.thread_id(), will be removed in a future release.
Copyright (c) 2000, 2025, Oracle Corporation and/or its affiliates. All rights reserved.