系统监控信息-SYS_ALL_MEM_STATUS
📄字数 481
👁️阅读量 加载中...
功能描述
SYS_ALL_MEM_STATUS系统表用于管理数据库所有节点内存状态。
字段说明
应用举例
- 查询所有节点内存状态
sql
SQL> SELECT * FROM SYS_ALL_MEM_STATUS;
+--------+--------------------------+-----------+----------------+---------------+----------------+--------------+--------------+---------------+--------------+--------------+---------------+----------------+---------------+
| NODEID | CURR_T | BUFF_SIZE | TOTAL_BUFF_NUM | FREE_BUFF_NUM | DIRTY_BUFF_NUM | LRU_BUFF_NUM | SGA_BLK_SIZE | TOTAL_SGA_MEM | FREE_SGA_MEM | PEAK_SGA_MEM | SWAP_BLK_SIZE | TOTAL_SWAP_MEM | FREE_SWAP_MEM |
+--------+--------------------------+-----------+----------------+---------------+----------------+--------------+--------------+---------------+--------------+--------------+---------------+----------------+---------------+
| 1 | 2025-06-30 14:37:43.939 | 8192 | 262144 | 249681 | 0 | 12462 | 8192 | 131072 | 131072 | 4 | 262144 | 512 | 512 |
| 2 | 2025-06-30 14:37:43.935 | 8192 | 262144 | 253815 | 0 | 8327 | 8192 | 131072 | 131072 | 1 | 262144 | 512 | 512 |
| 3 | 2025-06-30 14:37:43.942 | 8192 | 262144 | 254395 | 0 | 7747 | 8192 | 131072 | 131072 | 0 | 262144 | 512 | 512 |
+--------+--------------------------+-----------+----------------+---------------+----------------+--------------+--------------+---------------+--------------+--------------+---------------+----------------+---------------+