26.4.3.18 The memory_by_user_by_current_bytes and x$memory_by_user_by_current_bytes Views
These views summarize memory use, grouped by user. By default, rows are sorted by descending amount of memory used.
The memory_by_user_by_current_bytes and x$memory_by_user_by_current_bytes views have these columns:
-
userThe client user name. Rows for which the
USERcolumn in the underlying Performance Schema table isNULLare assumed to be for background threads and are reported with a host name ofbackground. -
current_count_usedThe current number of allocated memory blocks that have not been freed yet for the user.
-
current_allocatedThe current number of allocated bytes that have not been freed yet for the user.
-
current_avg_allocThe current number of allocated bytes per memory block for the user.
-
current_max_allocThe largest single current memory allocation in bytes for the user.
-
total_allocatedThe total memory allocation in bytes for the user.
© 2025 Oracle
Licensed under the GPLv2 License.