select username, sum(sharable_mem)"总共享内存", sum(persistent_mem)"打开游标内存", sum(runtime_mem)"运行时内存" from sys.v_$sqlarea a, dba_users b where a.parsing_user_id = b.user_id group by username
内存值最小单位为字节b
select username, sum(sharable_mem)"总共享内存", sum(persistent_mem)"打开游标内存", sum(runtime_mem)"运行时内存" from sys.v_$sqlarea a, dba_users b where a.parsing_user_id = b.user_id group by username
内存值最小单位为字节b
上一篇:oracle 最大连接数
下一篇:oracle update优化
一、内存结构的概述: Oracle用内存存储了以下信息: (1) program code (2) information about a connected session, ev
举报文章
请选择举报类型
补充说明
0/200
上传截图
格式支持JPEG/PNG/JPG,图片不超过1.9M