26.4.3.16 The memory_by_host_by_current_bytes and x$memory_by_host_by_current_bytes Views
These views summarize memory use, grouped by host. By default, rows are sorted by descending amount of memory used.
The memory_by_host_by_current_bytes and x$memory_by_host_by_current_bytes views have these columns:
-
hostThe host from which the client connected. Rows for which the
HOSTcolumn 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 host.
-
current_allocatedThe current number of allocated bytes that have not been freed yet for the host.
-
current_avg_allocThe current number of allocated bytes per memory block for the host.
-
current_max_allocThe largest single current memory allocation in bytes for the host.
-
total_allocatedThe total memory allocation in bytes for the host.
© 2025 Oracle
Licensed under the GPLv2 License.