Updated on 2025-05-29 GMT+08:00

GLOBAL_SHARED_MEMORY_DETAIL

Displays the usage of shared memory contexts on all normal nodes in the database, as shown in Table 1. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and the empty list is returned if this view is accessed in a PDB.

Table 1 GLOBAL_SHARED_MEMORY_DETAIL columns

Name

Type

Description

node_name

name

Node name.

contextname

text

Name of the memory context.

level

smallint

Level of the memory context.

parent

text

Name of the parent memory context.

totalsize

bigint

Total size of the shared memory (unit: byte).

freesize

bigint

Remaining size of the shared memory (unit: byte).

usedsize

bigint

Used size of the shared memory (unit: byte).