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内存
原文：http://jialong.blog.51cto.com/1104441/1658454
