SESSION_MEMORY_DETAIL

Collects statistics on the memory usage of threads on the current node, in the unit specified by MemoryContext, as shown in Table 1. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.

**Table 1** SESSION_MEMORY_DETAIL columns
Name	Type	Description
sessid	text	Thread start time and ID.
sesstype	text	Thread name.
contextname	text	Name of the memory context.
level	smallint	Level of memory context importance.
parent	text	Name of the parent memory context.
totalsize	bigint	Size of the allocated memory (unit: byte).
freesize	bigint	Size of the idle memory (unit: byte).
usedsize	bigint	Size of the used memory (unit: byte).